Oracle Exam 1Z0-084 Topic 3 Question 12 Discussion

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.

Oracle Database Reference: STATISTICS_LEVEL

Oracle Database Licensing Information User Manual: Oracle Database Management Packs