Query available snapshots and Removing a snapshot

To query the available snapshot you can use this query:

select snap_id, begin_interval_time, end_interval_time from dba_hist_snapshot order by snap_id;

To remove a snapshot:

exec dbms_workload_repository.drop_snapshot_range  (low_snap_id=>1, high_snap_id=>10);