RE: Buffer cache hot ratio

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Wed, 23 Jun 2004 22:06:08 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CFECFD21@bosmail00.bos.il.pqe>

Ok, you restarted the instance and the buffer cache hit ratio increased. Could be a lot of different reasons for that. I'm not sure what you mean by "buffer cache hot ration", which you apparently want to decrease. What does "buffer cache hot ration" mean?

Note that in general, the buffer cache hit ratio is not a valid performance metric. You're far better off on a per-business-function basis, starting with the most critical. Investigate it. Why is it not performing? Trace the session. See where that leads you.

Hope that helps,

-Mark

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

From:	oracle-l-bounce_at_freelists.org on behalf of Seema Singh
Sent:	Wed 6/23/2004 9:43 PM
To:	oracle-l_at_freelists.org
Cc:	
Subject:	Buffer cache hot ratio

Hi,
Why Buffre cache hit ratio some low and when we restart instance it came backup?
How to reduce buffer cache hot ration without changing the init.ora parameters?
thx

Watch the online reality show Mixed Messages with a friend and enter to win a trip to NY
http://www.msnmessenger-download.click-url.com/go/onm00200497ave/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

Binary/unsupported file stripped by Ecartis --
Type: application/ms-tnef
File: winmail.dat

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

Received on Wed Jun 23 2004 - 21:03:16 CDT