What are the least elevated values of statistics_level and C0NTR0LJ4ANAGEMENT_PACK_ACCESS that allow the usage of Monitoring of Database Operations?

Monitoring of Database Operations requires that the STATISTICS_LEVEL parameter be set to ALL and

CONTROL_MANAGEMENT_PACK_ACCESS be set to DIAGNOSTIC+TUNING. These settings enable all

the advisory features and automatic tuning features within the Oracle Database, including the

Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the

full functionality of the SQL Tuning Advisor and SQL Access Advisor, which are components of the

Diagnostic and Tuning packs.

STATISTICS_LEVEL=ALL: This setting enables the collection of all system statistics for problem

detection and self-tuning purposes.

CONTROL_MANAGEMENT_PACK_ACCESS=DIAGNOSTIC+TUNING: This grants access to both the

Diagnostic Pack and the Tuning Pack, which are essential for detailed performance monitoring and

tuning capabilities.

Reference:

Oracle Database Reference: STATISTICS_LEVEL

Oracle Database Licensing Information User Manual: Oracle Database Management Packs