Re: Buffer cache hits %

Hi,

I'm no guru... yet...

But, since you mention you have production and test db's of the same instance size, you might consider shifting some of the memory used by test to the production system.

Were running about a .5 GB SGAfor production. Our test db isn't hit so hard so, I believe that one is down around an SGA size of about 30MB.

Of course, you may need the same size SGA for timing tests, but if not, its an option to consider.

Ron

In article <O41ialrz#GA.309_at_nih2naae.prod2.compuserve.com>, kevin_gillins_at_compuserve.com says...
>
>This is a multi-part message in MIME format.
>
>------=_NextPart_000_0015_01BECE98.2C81AF80
>Content-Type: text/plain;
> charset="iso-8859-1"
>Content-Transfer-Encoding: 7bit
>
>I have a question about the buffer cache hits ratio we are experiencing.
>
>We are on 7.3.3.5 database using 10.7 oracle apps most all products. Apx
>100+ users.
>The database size is apx 40 gig. We are on HP 4 processors with 2.5 gig
>memory.
>There are 2 instances both the same size (prod and test). The shared pool
>is set
>at 250,000,000 running 6 db writers. The production instance is on EMC
>disks.
>
Received on Mon Jul 19 1999 - 15:31:50 CDT