However, it is not at all difficult to get a high BHR with Connor's script
(...if one *must* see those 'five 9s'...) at
http://www.oracledba.co.uk/. Click on Tuning and the on 'Custom Hit Ratio'.
While there, browse the site for some really useful things than "fixing" the
BHR.
- Kirti
-Or
...and a high cache hit ratio (>99%) is usually an indication of a
serious problem as well.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
-
;
cc:
Subject: RE: Cache hit ratio?
Seema
1. How low is too low? Basically, different applications will tend to
have
different BHR values (Buffer Hit Ratio).
2. BHR varies over time, and will depend a lot on the lengths of time
you
sample it, and what type of processing was run
Seema
1. How low is too low? Basically, different applications will tend to have
different BHR values (Buffer Hit Ratio).
2. BHR varies over time, and will depend a lot on the lengths of time you
sample it, and what type of processing was running.
3. A low BHR can lead you to a problem. Othe
There is a script available (search the archives) that will set the ratio to anything
you want...
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
Each new user of a new system uncovers a new class of bugs. -- Kernighan
If u r not kidding then attend hotsos clinic.
r u sure u r not kidding
can u catch the session which is not performing as it should from the end users
perspective?
get the top 5 wait events for that session.
> -Original Message-
> From: Seema Singh [mailto:[EMAIL PROTECTED]]
> Sent: We
Seema Singh wrote:
>
> Hi
> One of my database Cache Hit Ratio is low.I adjusted db_block_buffer and I
> have noticed after week again cache hit ratio became low.
> Can u please suggest what other things I can do to fix this problem?
> Thx
> -Seema
Use Connor's script.
--
Regards,
Stephane Far