常用的SQL语句
来自于:http://blog.csdn.net/jaguarcts/archive/2004/08/24/83741.aspx
数据文件的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;
原文转自:http://www.ltesting.net
|