AWR purging.
708661Jun 24 2009 — edited Sep 30 2009Hi All,
My sysaux tablespace is grown up to 25 GB. I"m using grid as well.
Default purging should have been done for AWR report, but didn't.
What should be my approach to purge it? Purging AWR with following is enough or do I need to do something else.
EXEC dbms_workload_repository.drop_snapshot_range(low_snap_id=>1150, high_snap_id=>1250);
How do I get which is the oldest dated data still stored in my AWR?
Thanks,
Raja.