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