select ts.name tsname
, tf.name filename
, tm.phyrds
, tm.phywrts
, tm.readtim
, tm.writetim
, tm.phyblkrd
, tm.phyblkwrt
, fw.count wait_count
, fw.time time
from x$kcbfwait fw
, v$tempstat tm
, v$tablespace ts
, v$tempfile tf
where ts.ts# = tf.ts#
and tm.file# = tf.file#
and fw.indx+1 = tf.file#
SELECT TS.NAME TSNAME
, TF.NAME FILENAME
, TM.PHYRDS
, TM.PHYWRTS
, TM.READTIM
, TM.WRITETIM
, TM.PHYBLKRD
, TM.PHYBLKWRT
, FW.COUNT WAIT_COUNT
, FW.TIME TIME
FROM X$KCBFWAIT FW
, V$TEMPSTAT TM
, V$TABLESPACE TS
, V$TEMPFILE TF
WHERE TS.TS# = TF.TS#
AND TM.FILE# = TF.FILE#
AND FW.INDX+1 = TF.FILE#
|
|
|