Re: Tuning Semaphores on Solaris

From: Hans Forbrich <forbrich_at_telusplanet.net>
Date: Sat, 10 May 2003 22:42:56 GMT
Message-ID: <3EBD7F24.725F75C1@telusplanet.net>

Mladen Gogala wrote:

> You need 1 semaphore / oracle process + several for fixed overhead.

Basically correct ...

Please go to OTN (http://otn.oracle.com), find the documentation, open the Install manual for Linux (or download the document http://download-east.oracle.com/docs/pdf/A96167_01.pdf) and look at page 55, aka 2-19

The proper definitions and requirements for shared memory and semphores are displyed there for anyone to see.

Please note that, according to the document, SEMMNI=128 is the default for many systems and that is too low for Oracle.

YMMV, but this discusses a single instance only - more instances = more resources. Received on Sat May 10 2003 - 17:42:56 CDT