select df.name 文件名, fs.phyrds 读次数, fs.phywrts 写次数, (fs.readtim / decode(fs.phyrds, 0, -1, fs.phyrds)) 读时间, (fs.writetim / decode(fs.phywrts, 0, -1, fs.phywrts)) 写时间 from v$datafile df, v$filestat fs where df.file# = fs.file# order by df.name
本文共 338 字，大约阅读时间需要 1 分钟。
select df.name 文件名, fs.phyrds 读次数, fs.phywrts 写次数, (fs.readtim / decode(fs.phyrds, 0, -1, fs.phyrds)) 读时间, (fs.writetim / decode(fs.phywrts, 0, -1, fs.phywrts)) 写时间 from v$datafile df, v$filestat fs where df.file# = fs.file# order by df.name
转载于:https://www.cnblogs.com/wanglibo/archive/2012/02/28/2372014.html