Re: Poor Buffer Hit Ratio

If you have a copy of Access 97 or 2000 go download my monitoring tool and use it find the culprit. You need to identify the sessions and related SQL that is causing the problem, you might find that it is one particlar session, statment or job.

http://www.freetechnicaltraining.com/homes/ethan/overlook.htm

In article <8eph7l$6tt$1_at_nnrp1.deja.com>,   junderhi_at_my-deja.com wrote:
> We are running Oracle 8.0.4 on an 8-way R50 with 1GB of physical
 memory. The
> machine is running 4 instances with the largest approximately 30GB in
 total
> size. This largest instance is using db_block_size of 4096 and has
 120000
> db_block_buffers. The instance previously had only 40000
 db_block_buffers,
> but after noticing our block buffer hit ratio of approx 70%, I
 tripled it.
> Unfortunately, we have not obvered a performance increase as the hit
 ratio is
> still 70%. We are considering doubling the physical memory, but I'm
 not
> convinced that this low hit ratio will be alleviated with a generic
 increase
> in physical memory. Any suggestions?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
http://www.freetechnicaltraining.com/home/ethan


Sent via Deja.com http://www.deja.com/
Before you buy.