VIEW: SYS.INT$DBA_HIST_FILESTATXS

Source

View Text - Preformatted

select f.snap_id, f.dbid, f.instance_number,
       f.file#, f.creation_change#, d.filename,
       d.ts#, coalesce(t.tsname, d.tsname) tsname, d.block_size,
       phyrds, phywrts, singleblkrds, readtim, writetim,
       singleblkrdtim, phyblkrd, phyblkwrt, wait_count, time,
       optimized_phyblkrd, decode(f.con_dbid, 0, f.dbid, f.con_dbid),
       con_dbid_to_id(decode(f.con_dbid, 0, f.dbid, f.con_dbid)) con_id
from DBA_HIST_SNAPSHOT sn, WRH$_FILESTATXS f, WRH$_DATAFILE d, WRH$_TABLESPACE t
where      f.dbid             = d.dbid
      and  f.file#            = d.file#
      and  f.creation_change# = d.creation_change#
      and  f.snap_id          = sn.snap_id
      and  f.dbid             = sn.dbid
      and  f.instance_number  = sn.instance_number
      and  f.con_dbid         = d.con_dbid
      and  d.dbid             = t.dbid(+)
      and  d.ts#              = t.ts#(+)
      and  d.con_dbid         = t.con_dbid(+)

View Text - HTML Formatted

SELECT F.SNAP_ID
, F.DBID
, F.INSTANCE_NUMBER
, F.FILE#
, F.CREATION_CHANGE#
, D.FILENAME
, D.TS#
, COALESCE(T.TSNAME
, D.TSNAME) TSNAME
, D.BLOCK_SIZE
, PHYRDS
, PHYWRTS
, SINGLEBLKRDS
, READTIM
, WRITETIM
, SINGLEBLKRDTIM
, PHYBLKRD
, PHYBLKWRT
, WAIT_COUNT
, TIME
, OPTIMIZED_PHYBLKRD
, DECODE(F.CON_DBID
, 0
, F.DBID
, F.CON_DBID)
, CON_DBID_TO_ID(DECODE(F.CON_DBID
, 0
, F.DBID
, F.CON_DBID)) CON_ID FROM DBA_HIST_SNAPSHOT SN
, WRH$_FILESTATXS F
, WRH$_DATAFILE D
, WRH$_TABLESPACE T WHERE F.DBID = D.DBID
AND F.FILE# = D.FILE#
AND F.CREATION_CHANGE# = D.CREATION_CHANGE#
AND F.SNAP_ID = SN.SNAP_ID
AND F.DBID = SN.DBID
AND F.INSTANCE_NUMBER = SN.INSTANCE_NUMBER
AND F.CON_DBID = D.CON_DBID
AND D.DBID = T.DBID(+)
AND D.TS# = T.TS#(+)
AND D.CON_DBID = T.CON_DBID(+)