Real-Time SQL Monitoring

Date Added: Dec 2009
Format: PDF

Real-time SQL monitoring, introduced in Oracle Database 11g, provides a very effective way to identify run-time performance problems with resource intensive long-running and parallel SQL statements. Interactive Enterprise Manager Screens display details of SQL execution using new, fine-grained SQL statistics that are tracked out-of-the-box with no performance penalty to production systems. Statistics at each step of the execution plan are tracked by key performance metrics, including elapsed time, CPU time, and number of reads and writes, I/O wait time and various other wait times. This allows DBAs to analyze SQL execution with greater detail than it was previously possible and decide whether to terminate the long running SQL, let the SQL complete, or send the SQL for tuning.