VIEW: SYS.INT$DBA_HIST_IOSTAT_DETAIL

Source

View Text - Preformatted

select io.snap_id, io.dbid, io.instance_number,
       io.function_id, nmfn.function_name,
       io.filetype_id, nmft.filetype_name,
       io.small_read_megabytes, io.small_write_megabytes,
       io.large_read_megabytes, io.large_write_megabytes,
       io.small_read_reqs, io.small_write_reqs,
       io.large_read_reqs, io.large_write_reqs,
       io.number_of_waits, io.wait_time,
       decode(io.con_dbid, 0, io.dbid, io.con_dbid),
       con_dbid_to_id(decode(io.con_dbid, 0, io.dbid, io.con_dbid)) con_id
  from  DBA_HIST_SNAPSHOT sn, WRH$_IOSTAT_DETAIL io,
        WRH$_IOSTAT_FUNCTION_NAME nmfn, WRH$_IOSTAT_FILETYPE_NAME nmft
  where     sn.snap_id         = io.snap_id
        and sn.dbid            = io.dbid
        and sn.instance_number = io.instance_number
        and io.function_id     = nmfn.function_id
        and io.dbid            = nmfn.dbid
        and io.filetype_id     = nmft.filetype_id
        and io.dbid            = nmft.dbid

View Text - HTML Formatted

SELECT IO.SNAP_ID
, IO.DBID
, IO.INSTANCE_NUMBER
, IO.FUNCTION_ID
, NMFN.FUNCTION_NAME
, IO.FILETYPE_ID
, NMFT.FILETYPE_NAME
, IO.SMALL_READ_MEGABYTES
, IO.SMALL_WRITE_MEGABYTES
, IO.LARGE_READ_MEGABYTES
, IO.LARGE_WRITE_MEGABYTES
, IO.SMALL_READ_REQS
, IO.SMALL_WRITE_REQS
, IO.LARGE_READ_REQS
, IO.LARGE_WRITE_REQS
, IO.NUMBER_OF_WAITS
, IO.WAIT_TIME
, DECODE(IO.CON_DBID
, 0
, IO.DBID
, IO.CON_DBID)
, CON_DBID_TO_ID(DECODE(IO.CON_DBID
, 0
, IO.DBID
, IO.CON_DBID)) CON_ID
FROM DBA_HIST_SNAPSHOT SN
, WRH$_IOSTAT_DETAIL IO
, WRH$_IOSTAT_FUNCTION_NAME NMFN
, WRH$_IOSTAT_FILETYPE_NAME NMFT
WHERE SN.SNAP_ID = IO.SNAP_ID
AND SN.DBID = IO.DBID
AND SN.INSTANCE_NUMBER = IO.INSTANCE_NUMBER
AND IO.FUNCTION_ID = NMFN.FUNCTION_ID
AND IO.DBID = NMFN.DBID
AND IO.FILETYPE_ID = NMFT.FILETYPE_ID
AND IO.DBID = NMFT.DBID