VIEW: SYS.INT$DBA_HIST_CELL_IOREASON

Source

View Text - Preformatted

select s.snap_id, s.dbid, s.cell_hash, s.incarnation_num,
       s.reason_id, nm.reason_name, s.requests, s.bytes,
       decode(s.con_dbid, 0, s.dbid, s.con_dbid),
       0 con_id
from WRH$_CELL_IOREASON s,
     WRH$_CELL_IOREASON_NAME nm,
    (select distinct snap_id, dbid
       from DBA_HIST_SNAPSHOT) sn
where      s.reason_id        = nm.reason_id
      and  s.dbid             = nm.dbid
      and  s.snap_id          = sn.snap_id
      and  s.dbid             = sn.dbid

View Text - HTML Formatted

SELECT S.SNAP_ID
, S.DBID
, S.CELL_HASH
, S.INCARNATION_NUM
, S.REASON_ID
, NM.REASON_NAME
, S.REQUESTS
, S.BYTES
, DECODE(S.CON_DBID
, 0
, S.DBID
, S.CON_DBID)
, 0 CON_ID FROM WRH$_CELL_IOREASON S
, WRH$_CELL_IOREASON_NAME NM
, (SELECT DISTINCT SNAP_ID
, DBID
FROM DBA_HIST_SNAPSHOT) SN WHERE S.REASON_ID = NM.REASON_ID
AND S.DBID = NM.DBID
AND S.SNAP_ID = SN.SNAP_ID
AND S.DBID = SN.DBID