FreeLists / oracle-l / RE: BUFFER CACHE RATIOS

["Cary Millsap" <cary.millsap@xxxxxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of syed jaffar hussain
Sent: Wednesday, May 02, 2001 9:27 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Seema Singh
Sent: Sunday, May 02, 2004 5:06 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------