RE: Semaphore Tuning Reference

From: Troiano, Paul (CAP, GEFA) <Paul.Troiano_at_gecapital.com>
Date: Fri, 1 Dec 2000 16:34:28 -0500
Message-Id: <10697.123448@fatcity.com>

Thanks,

It did help. Greatly. I also found this article on shared memory in the previous month's issue.

http://www.sunworld.com/sunworldonline/swol-09-1997/swol-09-insidesolaris_p. html
<http://www.sunworld.com/sunworldonline/swol-09-1997/swol-09-insidesolaris_p .html>

• Paul

		-----Original Message-----
		From:	Jeffery Stevenson [mailto:jeff_at_mpv.com]
		Sent:	Friday, December 01, 2000 12:35 PM
		To:	Multiple recipients of list ORACLE-L
		Subject:	RE: Semaphore Tuning Reference

		Platform specific Oracle Installation Guide will give a
little information
		and Adrian Cockcroft's Sun Performance and Tuning, Second
Edition book at
		least gives a better definition (than the Sun docs) of what
each parameter
		does.  There is also a fairly decent article from the Inside
Solaris section
		of SunWorld Online:

	
http://www.sunworld.com/sunworldonline/swol-10-1997/swol-10-insidesolaris-2.
		html

		HTH



		-----Original Message-----
		Sent: Friday, December 01, 2000 12:01 PM
		To: Multiple recipients of list ORACLE-L



		Does anyone know a good reference for setting the Semaphore
Facility and
		Shared Memory parameters in the /etc/system file? I have
checked several
		books (Sun docs. at docs.sun.com, Essential Sys Admin from
O'Reilly, and
		Oracle & UNIX perf. Tuning by Alomari, etc.) and have only
found basic
		descriptions of what each of the parameters are for, rather
than any mention
		of logic to applied to setting them based on system

configuration.

                Thanks in advance,

                Paul

                From the Sun Docs...

		Semaphore Facility
		----------------------------------
		seminfo_semmap	Number of entries in the semaphore map 
		seminfo_semmni	Number of semaphore identifiers 
		seminfo_semmns	Number of semaphores in the system 
		seminfo_semmnu	Number of processes using the undo facility
		seminfo_semmsl	Maximum number of semaphores, per id 
		seminfo_semopm	Maximum number of operations, per semaphore
call 
		seminfo_semume	Maximum number of undo structures per

process

                Note: The total number of undo structures allocated in the system is:

                seminfo_semmnu * seminfo_semume

		seminfo_semvmx	Semaphore maximum value
		seminfo_semaem	Maximum value for adjustment on exit

		Shared Memory
		------------------------------
		shminfo_shmmax	Maximum shared memory segment size 
		shminfo_shmmin	Minimum shared memory segment size 
		shminfo_shmmni	Number of shared memory identifiers 
		shminfo_shmseg	Segments, per process



		-- 

		Please see the official ORACLE-L FAQ: http://www.orafaq.com


		-- 

		Author: Troiano, Paul (CAP, GEFA)
		  INET: Paul.Troiano_at_gecapital.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                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).


		-- 

		Please see the official ORACLE-L FAQ: http://www.orafaq.com


		-- 

		Author: Jeffery Stevenson
		  INET: jeff_at_mpv.com

		Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
		San Diego, California        -- Public Internet access /

Mailing Lists         

---

                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).

Received on Fri Dec 01 2000 - 15:34:28 CST