查询某个表上的IO情况

SELECT st.dbsname,p.tabname,  sum(sin.ti_nrows) nrows,round(sum(sin.ti_nptotal*sd.pagesize/1024/1024),2)   total_size,

round(sum(sin.ti_npused*sd.pagesize/1024/1024),2)  used_size,sum(seqscans) as seqscans  ,  

sum( pagreads) diskreads, sum(bufreads) bufreads, sum( bufwrites) bufwrites,sum( pagwrites) diskwrites,sum( pagreads)+ sum( pagwrites)  disk_rsws ,

trunc ( decode ( sum(bufreads) , 0 , 0 , ( 100 - (( sum(pagreads) * 100 ) / sum(bufreads+pagreads))) ) , 2 ) as rbufhits ,

trunc ( decode ( sum(bufwrites) , 0 , 0 , ( 100 - (( sum(pagwrites) * 100 ) / sum(bufwrites+pagwrites))) ) , 2 ) as wbufhits  

from scp20:systables s , sysmaster:sysptprof p , sysmaster:systabinfo sin,  sysmaster:sysdbspaces sd,sysmaster:systabnames st  

where  s.tabid>99 and s.tabname = p.tabname   and p.dbsname=st.dbsname and sd.dbsnum = trunc(st.partnum/1048576)  

 and p.partnum=st.partnum and s.tabname=st.tabname  and st.partnum=sin.ti_partnum  and st.dbsname=' scp20 '

group by 1,2  

order by  11 desc;