I was asked about IOPS, so that a new server could be sized, this could help.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
set linesize 100 set head off SELECT 'Number of Small Reads :'|| sum(decode(name,'physical read total IO requests',value,0)- decode(name,'physical read total multi block requests',value,0)), 'Number of Small Writes:'|| sum(decode(name,'physical write total IO requests',value,0)- decode(name,'physical write total multi block requests',value,0)), 'Number of Large Reads :'|| sum(decode(name,'physical read total multi block requests',value,0)), 'Number of Large Writes:'|| sum(decode(name,'physical write total multi block requests',value,0)), 'Total Bytes Read :'|| sum(decode(name,'physical read total bytes',value,0)), 'Total Bytes Written :'|| sum(decode(name,'physical write total bytes',value,0)) FROM gv$sysstat / |
Your results might look something like:
|
1 2 3 4 5 6 |
Number of Small Reads :106883 Number of Small Writes:205903 Number of Large Reads :2791 Number of Large Writes:40298 Total Bytes Read :2009381888 Total Bytes Written :4188587008 |
Remember that statistics contained in the GV$ views are cumulative and therefore should be sampled. You…
