RE: SHARED Memory & Sema phores on SUN / LINUX for Oracle.

From: Vordos, Suzy <Suzy.Vordos_at_qwest.com>
Date: Thu, 21 Aug 2003 09:29:37 -0800
Message-ID: <F001.005CBFEA.20030821092937@fatcity.com>

Here's what I have for Sun. This info was derived from some docs at SunSolve which I can't find anymore, and the Sun Perf Tuning book by Adrian Cockcroft.  

• ----------------------------------
• Semaphores/Shared Memory for ORACLE
• ----------------------------------
• shmmax = max size per shared memory segment
• shmmin = min size per shared memory segment
• shmmni = max num shared memory identifiers
• shmseg = max num shared memory segments per process
• semmns = max num semaphores system wide (=semmni*semmsl)
• semmni = max num semaphore sets system wide (=semmnu)
• semmsl = max num semaphores per semaphore set (=semopm)
• semmnu = max num sempahore undo structures (=semmni)
• semmap = max entries per semaphore map (=semmni*semmsl)
• semopm = max operations per semop call (=semmsl)
• semume = max undo entries per process (=semmsl)
• semvmx = max value of a semaphore (cannot be > 32767)

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmns=4000
set semsys:seminfo_semmni=40
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmnu=40
set semsys:seminfo_semmap=4000
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767

-----Original Message-----
Sent: Thu 8/21/2003 9:01 AM
To: Multiple recipients of list ORACLE-L Cc:

Dear Friends,

Any good article to explain the above subject, SHARED Memory & Sema phores on SUN / LINUX for Oracle. I just know what is shared memory , sema phores are. But never involved practically much. Please also send me some typical configurations , with explanation(if possible )

Please send me details about ur UNIX production Oracle systems, and lot of examples. Any good we site with pictorial information.

NOTE: This is just for information only.

Thanks a lot.
Regards
Rajuveera

---

This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.

---

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net>  
-- 
Author: Veeraraju_Mareddi 
  INET: rajuveera_at_satyam.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
<http://www.fatcity.com>  
San Diego, California        -- Mailing list and web hosting services 
--------------------------------------------------------------------- 
To REMOVE yourself from this mailing list, send an E-Mail message 
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in 
the message BODY, include a line containing: UNSUB ORACLE-L 
(or the name of mailing list you want to be removed from).  You may 
also send the HELP command for other information (like subscribing). 




Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii"
Content-Transfer-Encoding: 7bit

The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists.  If you want a copy of the attachment which was
removed, contact the sender directly and ask for it to be sent to
you by private E-mail.

This warning is inserted into all messages containing binary
attachments which have been removed by ListGuru.  If you have questions
about this message, contact Postmaster_at_fatcity.com for clarification.

------_=_NextPart_000_01C36800.F0873B3F--
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Vordos, Suzy
  INET: Suzy.Vordos_at_qwest.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



application/ms-tnef attachment: stored

Received on Thu Aug 21 2003 - 12:29:37 CDT