Message-ID: <F001.0052C7D9.20030110085416@fatcity.com>
Date: Fri, 10 Jan 2003 08:54:16 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Jesse, Rich" <Rich.Jesse@qtiworld.com>
Subject: RE: BCHR Tuning
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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@qtiworld.com              Quad/Tech International, Sussex, WI USA


> -----Original Message-----
> From: Robert Eskridge [mailto:bryny@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@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@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).