--
--  Name: statspack_show_snaps.sql
--
--  Description: Statspack - Displays snapshots taken
--
--  Compatability: 8.1.x and above
--
--  Usage: @statspack_show_snaps
--
--
select SNAP_ID, to_char(SNAP_TIME,'YYYY-MM-DD HH24:MI:SS') timestamp, snap_level 
from STATS$SNAPSHOT
order by snap_id;