VIEW: SYS.INT$DBA_HIST_BG_EVENT_SUMMARY

Source

View Text - Preformatted

select e.snap_id, e.dbid, e.instance_number,
       e.event_id, en.event_name, en.wait_class_id, en.wait_class,
       total_waits, total_timeouts, time_waited_micro,
       decode(e.con_dbid, 0, e.dbid, e.con_dbid),
       0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_BG_EVENT_SUMMARY e, WRH$_EVENT_NAME en
where     sn.snap_id         = e.snap_id
      and sn.dbid            = e.dbid
      and sn.instance_number = e.instance_number
      and e.event_id         = en.event_id
      and e.dbid             = en.dbid

View Text - HTML Formatted

SELECT E.SNAP_ID
, E.DBID
, E.INSTANCE_NUMBER
, E.EVENT_ID
, EN.EVENT_NAME
, EN.WAIT_CLASS_ID
, EN.WAIT_CLASS
, TOTAL_WAITS
, TOTAL_TIMEOUTS
, TIME_WAITED_MICRO
, DECODE(E.CON_DBID
, 0
, E.DBID
, E.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_BG_EVENT_SUMMARY E
, WRH$_EVENT_NAME EN WHERE SN.SNAP_ID = E.SNAP_ID
AND SN.DBID = E.DBID
AND SN.INSTANCE_NUMBER = E.INSTANCE_NUMBER
AND E.EVENT_ID = EN.EVENT_ID
AND E.DBID = EN.DBID