RE: HIT RATIO

From: Deshpande, Kirti <kirti.deshpande_at_verizon.com>
Date: Tue, 19 Nov 2002 19:33:24 -0800
Message-ID: <F001.00507735.20021119193324@fatcity.com>

With Connor McDonald's script in the DBA tool kit, no one should be complaining about a bad BCHR. Ever.... :) ;-)

Get the script from his web site : http://www.oracledba.co.uk/

• Kirti

-----Original Message-----

Sent: Tuesday, November 19, 2002 3:24 PM To: Multiple recipients of list ORACLE-L

What problem? Seriously, the buffer cache hit ratio is a pretty meaningless value (for details on why, see Cary Millsap's papers on www.hotsos.com). Are your users complaining? Are you seeing behavior on the system (disk contention, etc.) that makes you expect that your users will be complaining soon?

--

Michael Brown				Glen Raven, Inc./Info Services
Senior Oracle DBA			1831 N. Park Ave
Phone: (336)586-1146			Glen Raven, NC 27217
Fax: (336)586-1382			mbrown_at_glenraven.com

-----Original Message-----

Sent: Tuesday, November 19, 2002 2:05 PM To: Multiple recipients of list ORACLE-L

Hi
One of my database showing hit ratio low (=75% approx).I increased the parameters.After last reboot hit ratio was looking great.Last reboot was last week.I am wondering again this ratio is 73% approx. How to fix this problem except Init.ora prameter change? Thx
-Seema

---

Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seema Singh
  INET: oracledbam_at_hotmail.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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.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). Received on Tue Nov 19 2002 - 21:33:24 CST