Re: buffer hit cache ratio

"JEDIDIAH" <jedithezealot_at_yahoo.com> wrote in message news:5121813f.0312261236.4c0d3220_at_posting.google.com...
> If you have hardware resources, you should make sure you're exploiting
> them properly. This means configuring your SGA accordingly as well as
> ensuring OS, applications and storage hardware similarly well configured.

For some reason I'm reminded of Windows, look loads of CPU,RAM and DISK lets use it all... I'm sure that isn't what is intended, but when new servers come with 4-16gb of RAM as standard why pick an SGA size of 1.5 - 6gb just because the resources are there.

> The BHCR isn't a silver bullet, just part of a long laundry list of
> things to check. Of course if it were completely meaningless, Oracle
> would leave it out of the statspack report. '-)

So 'tuning' is a process of box ticking? BCHR > 80% tick, LCHR > 99.5% tick, DBA salary > $70k tick etc etc. Tuning ought to be about finding what is causing your key processes to perform inadequately and improving them - running through a checklist just isn't as effective as focussing on response time.

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK