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 [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: Robert Eskridge [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
