Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle Init.ora Parameters

Re: Oracle Init.ora Parameters

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Fri, 28 May 2004 19:48:25 +0100
Message-ID: <HHMtc.347$ZT5.267@newsfe2-win>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US