Oracle database query database snapshot point ID interval

Set pagesize 150;

Col instart_fmt format A30

Col inst_name format A20

Col db_name format A20

Col snap_id for 999999999999

Col snapdat format A30

Col lvl for 999999999999

Select To_char (s.startup_time, ' dd Mon ' at "HH24:mi:ss ') instart_fmt

, Di.instance_name Inst_name

, Di.db_name db_name

, s.snap_id snap_id

, To_char (S.end_interval_time, ' dd Mon YYYY hh24:mi ') snapdat

, S.snap_level LVL

From Dba_hist_snapshot S

, Dba_hist_database_instance di

where di.dbid = S.dbid

and Di.instance_number = S.instance_number

and di.startup_time = S.startup_time

Order by Db_name, instance_name, snap_id;

Oracle database query database snapshot point ID interval