[Oracle Script] check File I/O
select dbf.tablespace_name,dbf.file_name, gvf.PHYRDS, gvf.PHYWRTS, round(gvf.phyrds / (gvf.PHYRDS + gvf.PHYWRTS),4)*100 || ' / '|| (1-round(gvf.phyrds / (gvf.PHYRDS + gvf.PHYWRTS),4))*100 "Phyrd/phywt Ratio" ,
round((gvf.PHYRDS + gvf.PHYWRTS) / (select sum(PHYRDS + PHYWRTS) from GV$FILESTAT),4)*100 "IO Ratio/Total",
gvf.PHYBLKRD, gvf.PHYBLKWRT, round(gvf.PHYBLKRD / (gvf.PHYBLKRD + gvf.PHYBLKWRT),4)*100 || ' / '|| (1-round(gvf.PHYBLKRD / (gvf.PHYBLKRD + gvf.PHYBLKWRT),4))*100 "Phyblkrd/Phyblkwt Ratio" ,
round((gvf.PHYBLKRD + gvf.PHYBLKWRT) / (select sum(PHYBLKRD + PHYBLKWRT) from GV$FILESTAT),4)*100 "IO Ratio/Total(Block)",
trunc(gvf.PHYBLKRD/gvf.PHYRDS) "Blocks per read" , trunc(gvf.PHYBLKWRT/gvf.PHYWRTS) "Blocks per write"
from GV$FILESTAT gvf,dba_data_files dbf
where gvf.file#=dbf.file_id and gvf.inst_id = USERENV('Instance')
round((gvf.PHYRDS + gvf.PHYWRTS) / (select sum(PHYRDS + PHYWRTS) from GV$FILESTAT),4)*100 "IO Ratio/Total",
gvf.PHYBLKRD, gvf.PHYBLKWRT, round(gvf.PHYBLKRD / (gvf.PHYBLKRD + gvf.PHYBLKWRT),4)*100 || ' / '|| (1-round(gvf.PHYBLKRD / (gvf.PHYBLKRD + gvf.PHYBLKWRT),4))*100 "Phyblkrd/Phyblkwt Ratio" ,
round((gvf.PHYBLKRD + gvf.PHYBLKWRT) / (select sum(PHYBLKRD + PHYBLKWRT) from GV$FILESTAT),4)*100 "IO Ratio/Total(Block)",
trunc(gvf.PHYBLKRD/gvf.PHYRDS) "Blocks per read" , trunc(gvf.PHYBLKWRT/gvf.PHYWRTS) "Blocks per write"
from GV$FILESTAT gvf,dba_data_files dbf
where gvf.file#=dbf.file_id and gvf.inst_id = USERENV('Instance')
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-2143140/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [Oracle Script] check userOracle
- [Oracle Script] check latchOracle
- [Oracle Script] check active sessionOracleSession
- [Oracle Script] check lock infoOracle
- [Oracle Script] check Literal SQLOracleSQL
- [Oracle Script] check tablespace usage infoOracle
- [Oracle Script] check temp tablespace usageOracle
- [Oracle Script] check object count by userOracleObject
- goldengate extract abended unable to queue I/O, I/O beyond file sizeGo
- HOW TO CHECK IF ASYNCHRONOUS I/O IS WORKING ON LINUXLinux
- 等待事件:Disk file operations I/O事件
- check ftp success scriptFTP
- script of check repair ASM DISKGROUPAIASM
- ORACLE UTL_FILE檔案包的應用,檔案I/O操作Oracle
- db file async I/O submit 等待事件優化MIT事件優化
- db file async I/O submit 等待事件說明MIT事件
- Oracle I/O問題解析Oracle
- Java I/O系統學習系列一:File和RandomAccessFileJavarandomMac
- db file async I/O submit等待事件的故障診斷MIT事件
- How To Check if Asynchronous I/O is Working On Linux (Doc ID 237299.1)Linux
- Using UTL_FILE Package To Perform File I/O (UNIX) And Basic FAQ_44307.1PackageORM
- Veritas Quick I/O and Cached Quick I/OUI
- Oracle I/O設定說明文件Oracle
- 計算機I/O與I/O模型計算機模型
- I/O埠和I/O記憶體記憶體
- I/O上的等待事件 —— control file sequential read/control file parallel write事件Parallel
- 減少ORACLE中的磁碟I/O(轉)Oracle
- Java I/OJava
- oracle之 調整 I/O 相關的等待Oracle
- 【Oracle-記憶體管理】-Multiple I/O SlavesOracle記憶體
- Java(8)I/OJava
- 【java】I/O流Java
- Java I/O流Java
- 檔案I/O
- I/O基礎
- java的I/OJava
- c++ I/OC++
- HOW TO CHECK IF ASYNCHRONOUS I/O IS WORKING ON LINUX轉自http://sundog315.itpub.net/LinuxHTTP