Changing ADDM Attributes

ADDM is controlled by the STATISTICS_LEVEL parameter.  By default, its setting is STATISTICS_LEVEL=TYPICAL.  ADDM analysis of I/O performance depends on the DBIO_EXPECTED parameter.  This parameter describes the expected performance of I/O subsystem.

To set the expected speed (default is 1000 ..10 ms)

SQL> exec DBMS_ADVISOR.set_default_task_parameter('ADDM','DBIO_EXPECTED',8000);

PL/SQL procedure successfully completed.

Select parameter_value, is_default

From dba_advisor_def_parameters

Where advisor_name = 'ADDM' and parameter_name = 'DBIO_EXPECTED'