[SunHELP] ORACLE & Solaris

[Bashar]

set shmsys:shminfo_shmmax = 8589934590
set shmsys:shminfo_shmmin = 1
set shmsys:shminfo_shmmni = 200
set shmsys:shminfo_shmseg = 20
set semsys:seminfo_semmni = 140
set semsys:seminfo_semmns = 400
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

	thats what i have under /etc/system , shal i add more ? and how
can i know its possible to add more or not (that my server can handle it
without crashing)


> This is the shared memory section of /etc/system from
> one of our larger database servers which had the same 
> problem several months ago.
> 
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmns=1024
> set semsys:seminfo_semmni=256 
> 
> 
> Les
> ----- Original Message ----- 
> From: "Bashar" <big at kuwaitnet.net>
> To: <sunhelp at sunhelp.org>
> Sent: Friday, March 16, 2001 11:14 PM
> Subject: [SunHELP] ORACLE & Solaris
> 
> 
> > Regards,
> > on our E3500 with dual UltraSparc 400mhz and 1024Mb ram hosting a
> > large oracle database this error repeated twice in the last 4 weeks the
> > error from alter_BILLING.log:
> > 
> > ORA-04031: unable to allocate 4096 bytes of shared memory
> > 
> >  is this error oracle based error or system ram/memory error ? although
> > the dba said he alocated 600mb of memory on the database startup.
> > 
> > 
> > 
> >                     KuwaitNet Communications Inc.
> >         Bashar A AlAbdulhadi            UNIX & NET Administrator
> >         bashar at kuwaitnet.net            http://www.KuwaitNet.net
> >         Phone: (KW) +965-2647060        Fax: (KW) +965-5337060
> >         Phone: (US) +514-2417955        Fax: (US) +208-2755778
> >         ICQ UIN: 19907999               Pager: (KW) 9312471
> >         IRC: Big @ #Kuwaitnet           YaHoO ID: kuwaitnets
> >         Toll free (from USA & Canada only)  1-888-KuwaitNET
> > 
> >            "Quality, Stability, 24 Hours Tech. Support"
> >                           "Think KuwaitNet"
> > 
> > _______________________________________________
> > SunHELP maillist  -  SunHELP at sunhelp.org
> > http://www.sunhelp.org/mailman/listinfo/sunhelp
> > 
> 
> _______________________________________________
> SunHELP maillist  -  SunHELP at sunhelp.org
> http://www.sunhelp.org/mailman/listinfo/sunhelp
>