Mar
24
2010
How to disable AWR Snapshot in 10g – change the Interval to 0
exec DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS( INTERVAL=>0 );
select * from DBA_HIST_WR_CONTROL
DBID SNAP_INTERVAL RETENTION TOPNSQL
1898043910 +40150 00:00:00.000000 +07 00:00:00.000000 30
