Performance & Diagnostics
Practical Oracle resources for understanding workload, wait events, SQL performance and database behaviour.
Practical performance investigation
A growing collection of queries and diagnostic resources for understanding Oracle database performance from workload and symptoms through to deeper investigation.
Wait Events
Understand database wait activity and use wait events as clues during performance investigation.
ExploreSQL Performance
Investigate SQL execution, resource consumption and performance characteristics.
ExploreSession Performance
Review active sessions, workload and session-level performance indicators.
ExploreBlocking & Locks
Investigate blocking sessions, locks and concurrency issues affecting database activity.
ExploreAWR & ASH
Practical resources for working with historical workload and active session information.
ExplorePerformance Diagnostics
A structured starting point for investigating database performance symptoms and workload behaviour.
ExplorePerformance investigation starts with evidence.
Use waits, sessions, SQL, workload and historical data together. A single metric or wait event rarely explains the complete performance problem.
Back to Tools