VIEW: SYS.INT$DBA_HIST_ASH_SNAPSHOT

Source

View Text - Preformatted

select s."SNAP_ID",s."DBID",s."INSTANCE_NUMBER",s."STARTUP_TIME",s."BEGIN_INTERVAL_TIME",s."END_INTERVAL_TIME",s."FLUSH_ELAPSED",s."SNAP_LEVEL",s."STATUS",s."ERROR_COUNT",s."BL_MOVED",s."SNAP_FLAG",s."SNAP_TIMEZONE", con_dbid_to_id(s.dbid) con_id
  from wrm$_snapshot s
 where s.status in (0,1)
   and s.flush_elapsed is not null
   and (s.snap_id,dbid,instance_number) not in
       (select e.snap_id,dbid,instance_number
          from WRM$_SNAP_ERROR e
         where e.table_name = 'WRH$_ACTIVE_SESSION_HISTORY')

View Text - HTML Formatted

SELECT S."SNAP_ID"
, S."DBID"
, S."INSTANCE_NUMBER"
, S."STARTUP_TIME"
, S."BEGIN_INTERVAL_TIME"
, S."END_INTERVAL_TIME"
, S."FLUSH_ELAPSED"
, S."SNAP_LEVEL"
, S."STATUS"
, S."ERROR_COUNT"
, S."BL_MOVED"
, S."SNAP_FLAG"
, S."SNAP_TIMEZONE"
, CON_DBID_TO_ID(S.DBID) CON_ID
FROM WRM$_SNAPSHOT S
WHERE S.STATUS IN (0
, 1)
AND S.FLUSH_ELAPSED IS NOT NULL
AND (S.SNAP_ID
, DBID
, INSTANCE_NUMBER) NOT IN (SELECT E.SNAP_ID
, DBID
, INSTANCE_NUMBER
FROM WRM$_SNAP_ERROR E
WHERE E.TABLE_NAME = 'WRH$_ACTIVE_SESSION_HISTORY')