Oracle DBA Lesson 104 Part 2 — Test resource policy against workload objectives

A resource policy can improve interactive response while delaying batch processing. A useful comparison establishes whether that tradeo...

Read the full lesson

Oracle DBA Lesson 104 Part 1 — Identify which resource control governs a workload

When interactive requests slow down while batch processing runs, first establish which control applies and what the sessions are waitin...

Read the full lesson

Oracle DBA Lesson 103 Part 3 — Review automatic tuning and hand off evidence

An automatic tuning report can describe SQL that was examined, actions that were recommended and changes that were implemented. The ope...

Read the full lesson

Oracle DBA Lesson 103 Part 2 — Assess SQL before and after a change

A database change can make some statements faster and others slower. A useful change assessment preserves comparable inputs, identifies...

Read the full lesson