VIEW: SYS.INT$DBA_HIST_IOSTAT_FILETYPE

Source

View Text - Preformatted

select io.snap_id, io.dbid, io.instance_number,
       nm.filetype_id, nm.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.small_sync_read_reqs,
       io.large_read_reqs, io.large_write_reqs,
       io.small_read_servicetime, io.small_write_servicetime,
       io.small_sync_read_latency,
       io.large_read_servicetime, io.large_write_servicetime,
       io.retries_on_error,
       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_FILETYPE io, WRH$_IOSTAT_FILETYPE_NAME nm
  where     sn.snap_id         = io.snap_id
        and sn.dbid            = io.dbid
        and sn.instance_number = io.instance_number
        and io.filetype_id     = nm.filetype_id
        and io.dbid            = nm.dbid

View Text - HTML Formatted

SELECT IO.SNAP_ID
, IO.DBID
, IO.INSTANCE_NUMBER
, NM.FILETYPE_ID
, NM.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.SMALL_SYNC_READ_REQS
, IO.LARGE_READ_REQS
, IO.LARGE_WRITE_REQS
, IO.SMALL_READ_SERVICETIME
, IO.SMALL_WRITE_SERVICETIME
, IO.SMALL_SYNC_READ_LATENCY
, IO.LARGE_READ_SERVICETIME
, IO.LARGE_WRITE_SERVICETIME
, IO.RETRIES_ON_ERROR
, 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_FILETYPE IO
, WRH$_IOSTAT_FILETYPE_NAME NM
WHERE SN.SNAP_ID = IO.SNAP_ID
AND SN.DBID = IO.DBID
AND SN.INSTANCE_NUMBER = IO.INSTANCE_NUMBER
AND IO.FILETYPE_ID = NM.FILETYPE_ID
AND IO.DBID = NM.DBID