查询某个表上的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;