RE: BUFFER CACHE RATIOS

From: syed jaffar hussain <sjaffarhussain_at_hotmail.com>
Date: Sun, 2 May 2004 09:14:19 -0500 (EST)
Message-ID: <001001c0d313$e3b7b240$840a010a@app02test>

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

Received on Sun May 02 2004 - 09:25:20 CDT