Re: Solaris Kernel Parameters

Will Greene wrote:

> Hello,
> I was reading through an Oracle Install manual where it says to set the
> solaris kernel parameters to such:
>
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_shmseg=10
> set semsys:seminfo_semmns=2000
> set semsys:seminfo_semmsl=1000
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
> Currently our settings in the etc/system file is set at:
>
> set shmsys:shminfo_shmmax=1073741824
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=1000
> set shmsys:shminfo_shmseg=200
> set semsys:seminfo_semmns=6000
> set semsys:seminfo_semmsl=1500
> set semsys:seminfo_semmni=1000
> set semsys:seminfo_semopm=100 (Not using this param)
> set semsys:seminfo_semvmx=32767 (Not using this param)
> set semsys:seminfo_semume=1000
> set semsys:seminfo_semmnu=1000
> set semsys:seminfo_semmap=1000
>
> Could someone help explain these settings to me to help me decide if these
> settings are ok? I am running a single database on a SunE450, 2 cpu @ 300Mhz
> with 2 channel raid 5. The database is about 10Gbs.
>
> Thanks,
> Will
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com

Based on my experience you will bang your head on an ORA-03113 sooner or later.

What possible purpose is served by ignoring Oracle's recommendation?

Just change the values as recommended in the pre-installation instructions and reboot.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)