willgreene99_at_hotmail.com said...
> 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
>
I did a Google search for "solaris shmsys" (without quotes) and got a
hit on Solaris docs at Sun site for Tunable Parameters. You might want
to do the same for semsys also.
--
/Karsten
DBA > retired > DBA
Received on Fri Jun 20 2003 - 10:52:09 CDT
