Xref: alice comp.databases.oracle.server:48395
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!feeder.qis.net!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: Mladen Gogala <mgogala@earthlink.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Help on Creating a bigger SGA
Date: Wed, 05 May 1999 22:19:31 -0400
Content-Transfer-Encoding: 7bit
References: <7gkpos$68n$1@concorde.ctp.com>
X-Posted-Path-Was: not-for-mail
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: 6 May 1999 02:17:53 GMT
X-ELN-Insert-Date: Wed May  5 19:25:04 1999
Organization: EarthLink Network, Inc.
Lines: 28
Mime-Version: 1.0
Message-ID: <3730FC33.4840E2@earthlink.net>
X-Mailer: Mozilla 4.51 [en] (X11; I; SunOS 5.6 i86pc)

Tim Richardson 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.
Put something like:
set shmsys:shminfo_shmmax=67108864
set shmsys:shminfo_shmmni=128
set shmsys:shminfo_shmseg=128
set semsys:seminfo_semmns=256
set semsys:seminfo_semmni=64
set semsys:seminfo_semmap=64
set semsys:seminfo_semmnu=128

in  the /etc/system file (at the end) and reboot the machine.
-- 
Mladen Gogala