Re: Tuning Semaphores on Solaris

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sat, 10 May 2003 13:06:32 -0700
Message-ID: <cZcva.37437$MJ5.20684@fed1read03>

10Squared wrote:
> Following the Oracle installation docs we set the environment as recommended
> for our Solaris server and the server was restarted. This system has 4 900
> MHz CPUs, no shortage of hard file space, and 16 GB RAM. In trying to
> create a new database we are seeing ORA-[27302, 27303, 27146, 27300] errors
> that appear to indicate the system settings aren't quite right. Other than
> just trying increasing settings, is there a systematic approach that can be
> used to calculate the various system parameters? Even though we may get the
> database creation process to succeed by tweaking some settings, we would
> like to make sure we are not hindering system performance or risking a
> failure during a high system load. Thanks for your time.
>
> Cheers,
>
> Jim
>

Below are from a E5500 with 8 CPUs & 16GB RAM; which currently supports 5 instances (V7.3.4.5 - V9.2.0.3)

oracle stuff set semsys:seminfo_semmap = 200 set semsys:seminfo_semmni = 200 set semsys:seminfo_semmns = 8192 set semsys:seminfo_semmnu = 30 set semsys:seminfo_semmsl = 8192 set semsys:seminfo_semopm = 10 set semsys:seminfo_semume = 10 set semsys:seminfo_semusz = 96 set semsys:seminfo_semvmx = 32767 set semsys:seminfo_semaem = 16384 set shmsys:shminfo_shmmax = 4094967296 set shmsys:shminfo_shmmin = 32 set shmsys:shminfo_shmmni = 1000 set shmsys:shminfo_shmseg = 128

HTH & YMMV HAND! Received on Sat May 10 2003 - 15:06:32 CDT