RE: BUFFER CACHE RATIOS

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Sat, 1 May 2004 21:44:36 -0500
Message-ID: <004c01c42fef$6b3fa980$6901a8c0@CVMLAP02>

How much you /should/ pay attention to buffer cache hit ratios hasn't changed. What has changed is the number of people who now know the truth. :)

For historical perspective, I offer this... Can you guess on which version of Oracle I was taught why a really high buffer cache hit ratio is a reliable indicator of a serious performance problem?

It was version 5.

...And the truth had been known long before that.

Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
* Nullius in verba *

Upcoming events:
- Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 Pittsburgh

- SQL Optimization 101: 5/3 Boston, 5/24 San Diego, 6/14 Chicago
- Hotsos Symposium 2005: March 6-10 Dallas
- Visit www.hotsos.com for schedule details...

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of syed jaffar hussain Sent: Wednesday, May 02, 2001 9:27 AM
To: oracle-l_at_freelists.org
Subject: RE: BUFFER CACHE RATIOS

Seema,

I think you are in old days. You don't need to worry about the hit ratio. Performance measurement has changed from hit ratio to wait event based.

Best Regards,

Syed Jaffar Hussain

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Seema Singh Sent: Sunday, May 02, 2004 5:06 PM
To: oracle-l_at_freelists.org
Subject: BUFFER CACHE RATIOS

Hi,

I noticed Buffer Cache Hit Ratio was 52% ,after increased db_block_buffers
only I see increase in 4% in buffer cahe hit ratio. change value from db_block_buffers = 14424 to db_block_buffers = 16000 Wondering how to improve more buffer cache ratio. thanks

MSN Toolbar provides one-click access to Hotmail from any Web page - FREE
download! http://toolbar.msn.com/go/onm00200413ave/direct/01/

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

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


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Sun May 02 2004 - 09:41:58 CDT