RE: BCHR Tuning

And it is! Quest's Spotlight on Oracle (the new v3.0 has some great graphing) has alerted me nine times this week that the BCHR on my production ERP/MRP system was 0.00%.

OF COURSE, I immediately bumped off the 200+ sessions, boosted the buffer cache by 25% and bounced the instance each time I got the alarm. ;)

Rich

Rich Jesse                           System/Database Administrator
Rich.Jesse_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Robert Eskridge [mailto:bryny_at_dfweahs.net]
> Sent: Friday, January 10, 2003 10:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: BCHR Tuning
>
>
> Of course it dropped dramatically. That's because you are no longer
> doing 99% of the buffer gets that you were wasting to begin with.
>
> If it drops my resource use and increases my performanc, I'd love to
> have a BCHR of 1%. (I know that's extreme, but wouldn't it be
> cool..?)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).