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
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
扫一扫
2万+
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
