SQL> set lines 100 pages 999 SQL> select snap_id, snap_level, to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') starting 2  from dba_hist_snapshot 3  order by 1; SNAP_ID SNAP_LEVEL STARTING ---------- ---------- ----------------- 11950          1 27/07/09 23:00:24 11951          1 28/07/09 00:00:25 11952          1 28/07/09 01:00:26 11953          1 28/07/09 02:00:27 11954          1 28/07/09 03:00:28 11955          1 28/07/09 04:00:30 11956          1 28/07/09 05:00:31 … Continue reading How to Display a List of All Snapshots from OMS →