[推荐] 测量数据文件IO实例

SQL>SELECT s.file#||'D' "FILE#+TYPE",d.name "DATAFILE",
s.phyrds,s.phywrts,
s.avgiotim,s.miniotim,
s.maxiowtm,s.maxiortm
FROM v$filestat s,v$datafile d
WHERE s.file#=d.file#
UNION
SELECT s.file#||'T',t.name "DATAFILE",
s.phyrds,s.phywrts,
s.avgiotim,s.miniotim,
s.maxiowtm,s.maxiortm
FROM v$filestat s,v$tempfile t
WHERE s.file#=t.file#
ORDER BY 1;