Re: Help on Creating a bigger SGA

From: Vincent Smith <vsmith_at_telstra.com.au>
Date: Tue, 18 May 1999 07:31:23 GMT
Message-ID: <374111c3.26698630@news.cdn.telstra.com.au>

Update the SHMMAX value to 1073741824 - this allows a 1GB shared memory segment - but do not use so much that pageing/swapping occurs with a full user load. Set the db_block_buffers to a realistic value based on the amount of machine RAM. Allow RAM for users sessions. The others are :

SHMMNI = 200
SHMSEG = 20
SEMMNS = (# of Oracle processes from init.ora + 100)
SEMMNI = 15 per instance

Check your Oracle hardware specific installation guide.

On Mon, 3 May 1999 13:28:07 -0700, "Tim Richardson" <tricha02_at_ctp.com> wrote:

>I am in the process of trying to allocate a bigger SGA and I receive the
>following error:
>
>07331, 00000, "smsnsg: unable to allocate the variable portion of the SGA."
>// *Cause: The variable portion of the SGA is too big to fit contiguously
>// into one segment.
>// *Action: Reconfigure the UNIX kernel to have bigger segments.
>
>
>I guess the problem is due to unix memory segment size, which is not big
>enough for the current SGA size.
>
>This is running on a Sun box.
>
>Any help would be greatly appreciated.
>
>
Received on Tue May 18 1999 - 02:31:23 CDT