But then again, if Oracle is the primary use on this machine , keep
increasing the size of the SGA until you start to page , and then reduce
back down again, try to get your buffer hit ratio above 95%, but dont spend
too much time exceeding that as the law of diminishing returns will apply.
SHARED_POOL_SIZE is dependant on the number and type of applications you
are running, as a guess I would set it at 16-24MB and see if you get any
error messages relating to fragmentation or lack of space in the shared
pool. log buffer size will depend on the number and type of updates to your
system, but I have never had to increase the size above 256K...
--
Adrian J Shepherd
swpatter_at_wwa.com wrote in article <345e8cca.3550157_at_news.wwa.com>...
> Oracle recommends that the SGA never exceeds 50% of your memory
> capacity.
>
>
>
> On Wed, 29 Oct 1997 20:10:07 GMT, khs_riderx_at_geocities.com (Darren
> Mallette) wrote:
>
> >Hello,
> >
> >I'm looking for some guidelines on sizing the SGA on 7.3.
> >Specifically, the server has 1 GB of RAM, and db_block_size is 2048.
> >That's all I know about this particular server. I'm interested in
> >hearing recommendations for db_block_buffers, log_buffer, and
> >shared_pool_size parameters. On a related note, how do you tell on NT
> >if processes are being swapped out of main memory to disk?
> >
> >Thanks in advance,
> >-Darren
> >
> >--
> >Remove the "x" to reply.
>
>
Received on Tue Nov 04 1997 - 00:00:00 CST
