Thanks Ed! 2000 isn't high enough for us (not even 4000 is high enough).
I need to know if there is a reason why it couldn't be set to 32767 i.e.
will the server take it if set to 32767? We're planning to add other
databases on this server and 8192 may not be enough then.

-----Original Message-----
From: Edwards Ed
[mailto:oracledba-ezmlmshield-x90496991.[Email address protected]
Sent: 30 April 2007 13:24
To: LazyDBA Discussion
Subject: RE: Semaphore settings

Well, well, wel,
It's cecile! Hehe. How have you been? Below is what my /etc/system
file looks like (Solaris 9).


set noexec_user_stack=1
set rlim_fd_max=65536
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=1500
set semsys:seminfo_semmns=2000
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767



Ensure that your spellings are correct! Hehe.





Please take a few minutes to provide feedback on the quality of service
you received from our staff. The Department of Education values your
feedback as a customer. Commissioner of Education Jeanine Blomberg is
committed to continuously assessing and improving the level and quality
of services provided to you.Simply use the link below. Thank you in
advance for completing the survey.


http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]




-----Original Message-----
From: cecile
[mailto:oracledba-ezmlmshield-x20190260.[Email address protected]
Sent: Monday, April 30, 2007 8:19 AM
To: LazyDBA Discussion
Subject: Semaphore settings

Hi All,

We're starting a new database but the server is complaining about the
semaphore settings. The current setting for semmns is 4000. Are there
any limits as to what this can be increased to? Can it be increased to
32767 (like semvmx)?

Thanks.
Cecile


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page