Database Tuning (MOSC)

MOSC Banner

drop_snapshot_range question

edited Nov 29, 2017 1:15PM in Database Tuning (MOSC) 8 commentsAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center