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.