Re: Oracle Init.ora Parameters

Mill wrote:

> 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.

Throwing more RAM at a server is not a recipe for better performance. In some cases it can make performance worse. So just throwing a few larger integers at you is a meaningless exercise and as I am sure you know tuning is not a trivial matter.

First ... why are you buying the RAM? What is it in your STATSPACK analysis that makes you think this is a good idea?

When we know that we may be able to help you with whether you just wasted money and, if not, where the resource might be best put to use. We need numbers and facts related to resources. If you don't have them ... I'd send the RAM back to the supplier.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)