Re: hit ratio

From: Roy Klassen <rklassen_at_pei.sympatico.ca>
Date: 1997/08/21
Message-ID: <01bcadd5$b1f08320$b51f22cf@fred.sympatico.ca>#1/1

Increase the SHARED_POOL_SIZE init variable. You should be be getting atleast 98-99 hit ratio.

Roy Klassen rklassen_at_pei.sympatico.ca

Pavel <peroutka_at_apple.com> wrote in article <5tfn2c$1064$1_at_news.apple.com>...
> To all,
>
> I created a database with 400m of buffer cache on machine which have
> 2gig memory. This database is using CONTEXT option. The database is
> accessed by about 100 users at the time.
> The database seems to be performing all right but hit ratio is
> suggesting that I need more db_buffers (56%). It seems to me that
> 400meg should be more than enough.
> Any advice how to deal with this besides increasing db_block_buffers
> parameter?
>
> Thanks,
>
> Paul
>
Received on Thu Aug 21 1997 - 00:00:00 CDT