Re: buffer gets per execution

"Imran Rahim" <i_rahim_at_hotmail.com> wrote in message news:e7519cfe.0306040851.1ab0ac24_at_posting.google.com...
> Hi
>
> When measuring buffer gets per execution, how do you decide whether
> the hits are too high or just right ?

Its *always* too high. *always*. The best sql statement is the one that never gets executed, the next best is the one that does 1 LIO per call.

 However if the data is being returned fast enough for the users of the application, then tuning is done. If it isn't then find out where the app is spending its time - you can 10046 trace to do this, and usually it will be a very few statements that account for nearly all the response time, see if you can make them more efficient (usually you can).

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************