VIEW: SYS.INT$DBA_HIST_EVENT_HISTOGRAM

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,
       e.wait_time_milli, e.wait_count,
       decode(e.con_dbid, 0, e.dbid, e.con_dbid),
       0 con_id
from DBA_HIST_SNAPSHOT sn, WRH$_EVENT_HISTOGRAM 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
, E.WAIT_TIME_MILLI
, E.WAIT_COUNT
, DECODE(E.CON_DBID
, 0
, E.DBID
, E.CON_DBID)
, 0 CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_EVENT_HISTOGRAM 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