Re: Database Buffer Cache Hit Ratio

On Wed, 05 Oct 2005 16:07:54 -0700, Joel Garry interested us by writing:

> I do disagree with one thing said, viz., not to do anything if no one
> is complaining.

Is this in response to my comment? If so, you misunderstood. I meant 'don't tune unless there is a legit reason, such as user complaints.'

I've seen DBAs 'tune' because BCHR was low, not because there was a problem with the system. Waste of time, generally because they did not understand what was happening. (Been guilty of that myself, some time ago. Learned with experience and careful guidance by some on this ng.)

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***