1. Get Started with Performance Tuning
  2. Proactive Database Tuning
  3. Monitoring Real-Time Database Operations
  4. About Monitoring Database Operations
  5. Enabling Monitoring of Database Operations

Enabling Monitoring of Database Operations

Real-time database operations monitoring is enabled by default when the STATISTICS_LEVEL initialization parameter is either set to TYPICAL (the default value) or ALL. Because database operations monitoring is a feature of the Oracle Tuning Pack, the CONTROL_MANAGEMENT_PACK_ACCESS parameter must be set to DIAGNOSTIC+TUNING (the default value).

See Also:

Oracle Database SQL Tuning Guide for more information about how to disable real-time database operations monitoring