First page Back Continue Last page Summary Graphics
Analyzing result II
If Execute physical reads + Fetch physical reads is more than 10% of Execute query+Execute current+ Fetch query+Fetch current then try to increase buffer cache
If Fetch query is high and Fetch rows is much lower, check if indexes are defined and used
If total elapsed column>250 (2.5 sec) for online queries, try to tune the SQL
If library cache misses excceeds 5% of the count, tune shared pool
Notes: