DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_ASH_SNAPSHOT

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","STARTUP_TIME","BEGIN_INTERVAL_TIME","END_INTERVAL_TIME","FLUSH_ELAPSED","SNAP_LEVEL","STATUS","ERROR_COUNT","BL_MOVED","SNAP_FLAG","SNAP_TIMEZONE","CON_ID" from INT$DBA_HIST_ASH_SNAPSHOT
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "STARTUP_TIME"
, "BEGIN_INTERVAL_TIME"
, "END_INTERVAL_TIME"
, "FLUSH_ELAPSED"
, "SNAP_LEVEL"
, "STATUS"
, "ERROR_COUNT"
, "BL_MOVED"
, "SNAP_FLAG"
, "SNAP_TIMEZONE"
, "CON_ID"
FROM INT$DBA_HIST_ASH_SNAPSHOT