How to Check/Verify the ADDM is enabled in Oracle Database?



The Eucharistic Miracles of the World
The Automatic Database Diagnostic Monitoring is enabled by default in Oracle database and it is determined by the initialization parameter called STATISTICS_LEVEL. There are 3 values allowed for this parameter – BASIC, ALL and TYPICAL. If the value for the parameter is set as TYPICAL or ALL then the ADDM is enabled for your database. If you set the value to BASIC many of the oracle features will get disabled including ADDM and it is strongly discouraged.

 SQL> show parameter statistics_level
NAME                                 TYPE                             VALUE
------------------------------------ -------------------------------- -------
statistics_level                     string                           TYPICAL


Website Stats


Post a Comment


Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2) Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer