VIEW: SYS.INT$DBA_HIST_SYSTEM_EVENT

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,
       total_waits_fg, total_timeouts_fg, time_waited_micro_fg,
       decode(e.con_dbid, 0, e.dbid, e.con_dbid),
       0  con_id
from DBA_HIST_SNAPSHOT sn, WRH$_SYSTEM_EVENT e, WRH$_EVENT_NAME en
where     e.event_id         = en.event_id
      and e.dbid             = en.dbid
      and e.snap_id          = sn.snap_id
      and e.dbid             = sn.dbid
      and e.instance_number  = sn.instance_number

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
, TOTAL_WAITS_FG
, TOTAL_TIMEOUTS_FG
, TIME_WAITED_MICRO_FG
, DECODE(E.CON_DBID
, 0
, E.DBID
, E.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_SYSTEM_EVENT E
, WRH$_EVENT_NAME EN WHERE E.EVENT_ID = EN.EVENT_ID
AND E.DBID = EN.DBID
AND E.SNAP_ID = SN.SNAP_ID
AND E.DBID = SN.DBID
AND E.INSTANCE_NUMBER = SN.INSTANCE_NUMBER