Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

SHMMNI,SEMMNI,SEMMNS,MSGMNI

mahdi bashiri_2
Occasional Visitor

SHMMNI,SEMMNI,SEMMNS,MSGMNI

HI
I have 2 questions :
1- After some times that i think related to number of process ,when process reach to specify process number all of the client hang it and can not do anything until many process killed by hand in sco oracle 8.1.7 on sco unixware 7.1.1 ( i have got ORA-04020 error )
2- how can i determine rela value of SHMMNI,SEMMNI,SEMMNS,MSGMNI parameters on sco unixware 7.1.1 that oracle 8.1.7 installed it?
3 REPLIES
Eric Antunes
Honored Contributor

Re: SHMMNI,SEMMNI,SEMMNS,MSGMNI

Hi,

First of all, the recomended values are for the maximums:

semmns = 8192
msgmax = 8192
shmmax = 1073741824

Have you very different values?

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Steven E. Protter
Exalted Contributor

Re: SHMMNI,SEMMNI,SEMMNS,MSGMNI

See about the unixware equivalent to nproc and maxuprc

Either of those could cause the behavior you are experiences. Running out of total system processes or max processes assigned to any one user.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Eric Antunes
Honored Contributor

Re: SHMMNI,SEMMNI,SEMMNS,MSGMNI

Hi,

Sorry, shmmax dependes on your amount of physical memory...

For the other kernel parameters, see this:

http://h21007.www2.hp.com/dspp/files/unprotected/database/HP3KOracle.ppt
Each and every day is a good day to learn.