RE: Buffer cache hot ratio
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 23 Jun 2004 22:06:08 -0400
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@xxxxxxxxxxxxx on behalf of Seema Singh
Sent: Wed 6/23/2004 9:43 PM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
