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博客 ” ，链接：https://blog.itpub.net/24237320/viewspace-2143140/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- [Linux7] HA Package Yum源配置
- [ASM] ORA-15032 ORA-15260
- [RAC] Oracle11g RAC禁止DB自动启动
- [Oracle] Device Checks for ASM - This is a pre-check........
- [Linux7] Centos7 multipath 盘权限绑定.
- [Linux7] zabbix 3.2.11安装
- [Oracle] Error in invoking target 'agent nmhs' of makefile
- [Linux] 查看环境变量
- [HPUX] HP Unix server vg自动激活
- [HPUX] UX:vxfs mount: ERROR: V-3-21264
