Re: Statspack Interpretation

From: Micha³ Kuratczyk <kura_at_lj.pl>
Date: Thu, 20 Apr 2006 15:03:08 +0200
Message-ID: <e280qf$ijt$1@abg.com.pl>

mccmx_at_hotmail.com wrote:
> The total time for the top 5 I/O SQLs is not even 10% of the total wait
> time for the i/o related waits...

Maybe the application doesn't use bind variables and therefore many of the queries are run just once (they are considered different even though they differ only in the values). A single execution is not enough to make it to the top 5 but all of those queries together sum to 90% of the load.

You can check your SGA for queries not using bind variables using the technique presented here:
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1163635055580

Just a food for thought.

-- 
Michal Kuratczyk

Received on Thu Apr 20 2006 - 08:03:08 CDT