FreeLists / oracle-l / RE: BUFFER CACHE RATIOS

["syed jaffar hussain" <sjaffarhussain@xxxxxxxxxxx>]

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
-----------------------------------------------------------------