Home  >  Oracle Database Administration (DBA)  >  Scripts  >  Get (statspack) snapshot information

SELECT snap_id,

               TO_CHAR (snap_time, 'DD.MM.YYYY HH24:MI:SS') "Date/Time",
               session_id,

               serial#
FROM stats$snapshot
ORDER BY snap_time desc;