Deep Dive into Oracle 11g AWR Report Metrics and Optimization
Report Overview and Core Metrics
An Automatic Workload Repository (AWR) report requires a minimum of two snapshots to generate meaningful delta statistics. These snapshots must belong to the same database instance without an intermediate restart. The report calculates metrics by comparing the end snapshot values against the start snapshot value ...
Posted on Thu, 23 Jul 2026 16:05:27 +0000 by coolfool
Analyzing Oracle Database Activity with v$session, v$active_session_history, and dba_hist_active_session_history
Oracle databases provide several dynamic performance views for monitoring session activity, performance tuning, and troubleshooting. Key views include v$session, v$active_session_history, and dba_hist_active_session_history. For multi-node environments, gv$session and gv$active_session_history offer consolidated information across all instances ...
Posted on Tue, 02 Jun 2026 18:48:03 +0000 by GFXUniverse