Oracle Init.ora Parameters

From: Mill <mill.h_at_ntlworld.com>
Date: Wed, 26 May 2004 15:59:23 +0100
Message-ID: <xd3tc.274$oy6.188@newsfe2-gui.server.ntli.net>

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. Received on Wed May 26 2004 - 09:59:23 CDT