Shulou(Shulou.com)06/01 Report--

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. Startups timekeeping instart_fmt dd Mon "at" HH24:mi:ss')

, di.instance_name inst_name

, di.db_name db_name

, s.snap_id snap_id

, to_char (s. Endpoints intervalidated timestamp 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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.