drop_snapshot_range question
Hi,
Oracle DB version: 12.1.0.1.0
I ran the following query on my database to get the min and max snap_ids:
select min(snap_id), max(snap_id) from WRH$_ACTIVE_SESSION_HISTORY;
MIN(SNAP_ID) MAX(SNAP_ID)
------------------ --------------------
1 11385
I then the following to drop snapshots:
execute dbms_workload_repository.drop_snapshot_range (low_snap_id => 1, high_snap_id => 1000);
After running the drop_snapshot_range command and it returns the prompt, I run min/max snap_id query again and get:
MIN(SNAP_ID) MAX(SNAP_ID)
------------------ --------------------
250 11385
I've tried other ranges like 1000 to 1500, but the query still comes back with a min(snap_id) of 250.