DBA Data[Home] [Help]

VIEW: SYS.INT$DBA_HIST_SNAPSHOT

Source

View Text - Preformatted

select snap_id, dbid, instance_number, startup_time,
       begin_interval_time, end_interval_time,
       flush_elapsed, snap_level, error_count, snap_flag, snap_timezone,
       con_dbid_to_id(dbid) con_id
from WRM$_SNAPSHOT
where status = 0
View Text - HTML Formatted

SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, STARTUP_TIME
, BEGIN_INTERVAL_TIME
, END_INTERVAL_TIME
, FLUSH_ELAPSED
, SNAP_LEVEL
, ERROR_COUNT
, SNAP_FLAG
, SNAP_TIMEZONE
, CON_DBID_TO_ID(DBID) CON_ID FROM WRM$_SNAPSHOT WHERE STATUS = 0