DBA Hub

📋Steps in this guide1/1

Purge old awr snapshots

-- Find the AWR snapshot details.

oracle configurationintermediate
by OracleDba
12 views
1

Purge old awr snapshots

Code/Command (click line numbers to comment):

1
2
3
4
5
6
-- Find the AWR snapshot details.
select snap_id,begin_interval_time,end_interval_time from sys.wrm$_snapshot order by snap_id
-- Purge snapshot between snapid 612 to 700
execute dbms_workload_repository.drop_snapshot_range(low_snap_id =>612 , high_snap_id =>700);
-- Verify again
select snap_id,begin_interval_time,end_interval_time from sys.wrm$_snapshot order by snap_id

Comments (0)

Please to add comments

No comments yet. Be the first to comment!