Init.ora Parameters & Memory

From: Mill <mill.h_at_ntlworld.com>
Date: Wed, 26 May 2004 16:20:30 +0100
Message-ID: <Tv3tc.278$oy6.3@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 WOULD 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 - 10:20:30 CDT