Paul,

Thanks for the reply. The retention period is set to 8 days. But a select on dba_hist_snapshot view returns 0 rows. But it the WRH$ tables I see snap_id going back to last year. Do you want to delete using dbms_workload_repository.drop_snapshot_range procedure. Please let me know.

Thanks,

kanas