IO_TUNNING
1. 求數據文件的I/O分布
SELECT df.name,
phyrds,
phywrts,
phyblkrd,
phyblkwrt,
singleblkrds,
readtim,
writetim
FROM v$filestat fs, v$dbfile df
WHERE fs.file# = df.file#
ORDER BY df.name;
2. 監控tablespace的I/O分布
SELECT df.tablespace_name name,
df.file_name "file",
f.phyrds pyr,
f.phyblkrd pbr,
f.phywrts pyw,
f.phyblkwrt pbw
FROM v$filestat f, dba_data_files df
WHERE f.file# = df.file_id
ORDER BY df.tablespace_name;
3. 監控文件系統的I/O分布
SELECT SUBSTR (a.file#, 1, 2) "#",
SUBSTR (a.name, 1, 30) "Name",
a.status,
a.bytes,
b.phyrds,
b.phywrts
FROM v$datafile a, v$filestat b
WHERE a.file# = b.file#;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/25198367/viewspace-688909/ ，如需转载，请注明出处，否则将追究法律责任。
