Re: Oracle Init.ora Parameters

"Mill" <mill.h_at_ntlworld.com> wrote in message news:xd3tc.274$oy6.188_at_newsfe2-gui.server.ntli.net...
> Hi
>
> I am running a Oracle 8.1.7.4 database on W2k Adv Server with 2gb Ram, we
> are
> planning to upgrade the RAM to 8gb, i understand i will need to adjust the
> db_block_buffers & shared_pool_size in the init.ora to utilise the new
> memory and
> make a larger SGA.
>
> My parameters are as follows for these settings.
>
> db_block_buffers = 1200
> shared_pool_size = 1000000000
>
>
> Can someone recommend new settings for these given the fact that i am
adding
> new
> memory to the server, my main concern is to correctly configure these so i
> don't get
> excessive paging and swapping, I appreciate it will need tweaking after i
> have run the
> system for awhile and monitored things
>
> Your comments greatly Appreciate
>
> Mill.
>
>

Thats nearly a gig for the shared pool - way way way way oversized, whats the chances that youa re not using bind variables and you think throwing ram at it will solve your issues? Received on Fri May 28 2004 - 13:48:25 CDT