梦想有多远

本文来自qiuyb 

Dba做日常Oracle的维护SQL相当多，我的近百个，如下的几个是经常用的，不断的会在本文档添加。

1、文件IO统计
select TS.Name,
DF.Name File_Name,
FS.Phyblkrd Blocks_Read,
FS.Phyblkwrt Blocks_Written,
FS.Phyblkrd+FS.Phyblkwrt Total_IOs
from V$FILESTAT FS, V$DATAFILE DF,v$tablespace TS
where DF.File#=FS.File#
AND DF.ts#=TS.TS#
order by FS.Phyblkrd+FS.Phyblkwrt desc;

(全文…)

本文来自qiuyb 

Dba做日常Oracle的维护SQL相当多，我的近百个，如下的几个是经常用的，不断的会在本文档添加。

1、文件IO统计
select TS.Name,
DF.Name File_Name,
FS.Phyblkrd Blocks_Read,
FS.Phyblkwrt Blocks_Written,
FS.Phyblkrd+FS.Phyblkwrt Total_IOs
from V$FILESTAT FS, V$DATAFILE DF,v$tablespace TS
where DF.File#=FS.File#
AND DF.ts#=TS.TS#
order by FS.Phyblkrd+FS.Phyblkwrt desc;

(全文…)

Reliable, requires two reboots and works without additional tools.

# ioscan -f | grep -e INTERFACE -e DEVICE |
grep -v target |
awk ‘{print $3, $1, $2}’ > /infile

(全文…)