VIEW: SYS.INT$DBA_HIST_SVC_WAIT_CLASS

Source

View Text - Preformatted

select st.snap_id, st.dbid, st.instance_number,
       st.service_name_hash, nm.service_name,
       wait_class_id, wait_class, total_waits, time_waited,
       decode(st.con_dbid, 0, st.dbid, st.con_dbid),
       con_dbid_to_id(decode(st.con_dbid, 0, st.dbid, st.con_dbid)) con_id
  from DBA_HIST_SNAPSHOT sn, WRH$_SERVICE_WAIT_CLASS st,
       WRH$_SERVICE_NAME nm
  where    st.service_name_hash = nm.service_name_hash
      and  st.dbid              = nm.dbid
      and  st.snap_id           = sn.snap_id
      and  st.dbid              = sn.dbid
      and  st.instance_number   = sn.instance_number
      and  st.con_dbid          = nm.con_dbid

View Text - HTML Formatted

SELECT ST.SNAP_ID
, ST.DBID
, ST.INSTANCE_NUMBER
, ST.SERVICE_NAME_HASH
, NM.SERVICE_NAME
, WAIT_CLASS_ID
, WAIT_CLASS
, TOTAL_WAITS
, TIME_WAITED
, DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)
, CON_DBID_TO_ID(DECODE(ST.CON_DBID
, 0
, ST.DBID
, ST.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_SERVICE_WAIT_CLASS ST
, WRH$_SERVICE_NAME NM
WHERE ST.SERVICE_NAME_HASH = NM.SERVICE_NAME_HASH
AND ST.DBID = NM.DBID
AND ST.SNAP_ID = SN.SNAP_ID
AND ST.DBID = SN.DBID
AND ST.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
AND ST.CON_DBID = NM.CON_DBID