Friday, June 24, 2011

I/O Activity Datafiles

SELECT ts.name AS ts, fs.phyrds "Reads", fs.phywrts "Writes"
      ,fs.phyblkrd AS br, fs.phyblkwrt AS bw
      ,fs.readtim "RTime", fs.writetim "WTime"
FROM v$tablespace ts, v$datafile df, v$filestat fs
WHERE ts.ts# = df.ts# AND df.file# = fs.file#
UNION
SELECT ts.name AS ts, ts.phyrds "Reads", ts.phywrts "Writes"
      ,ts.phyblkrd AS br, ts.phyblkwrt AS bw
      ,ts.readtim "RTime", ts.writetim "WTime"
FROM v$tablespace ts, v$tempfile tf, v$tempstat ts
WHERE ts.ts# = tf.ts# AND tf.file# = ts.file# ORDER BY 1;

No comments:

Post a Comment