Change ADDM/AWR Snapshot interval to 2 minute

Change ADDM/AWR Snapshot interval to 2 minute

sqlplus -s /NOLOG

set echo on

connect / as sysdba

exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT();

grant dba to SH;

rem -- event to allow setting very short Flushing interval

alter session set events '13508 trace name context forever, level 1';

rem -- change INTERVAL setting to 2 minutes

rem -- change RETENTION setting to 6 hours (total of 180 snapshots)

execute dbms_workload_repository.modify_snapshot_settings(interval => 2,retention => 360);

rem -- play with ADDM sensitiveness

exec dbms_advisor.set_default_task_parameter('ADDM','DB_ACTIVITY_MIN',30);

alter user sh account unlock;

alter user sh identified by sh;