SUMMARY: Re: V880, Solaris 9, Oracle questions

Sorry this is a bit late, but here are some of the parameters people 
recommended I look at, set, etc.
One note several mentioned was too look at the following on 
docs.sun.com:

Solaris Tunable Parameters Reference Manual

The above has a good detailed listing of various parameters for Solaris.

Thanks to all who replied!

___________________________
set rlim_fd_cur=1024
set rlim_fd_max=1024
set tune_t_fsflushr=5
set autoup=60
set ufs:ufs_HW=16777216
set ufs:ufs_LW=8388608
set bufhwm=32000
set segspt_minfree=0x4000

# depending on memory, the following parameters should be adjusted as 
well:
set shmsys:shminfo_shmmax=34359738368
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=100

set semsys:seminfo_semmni=4096
set semsys:seminfo_semmsl=16010
set semsys:seminfo_semmns=65535
set semsys:seminfo_semmnu=1024
set semsys:seminfo_semume=512
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

set msgsys:msginfo_msgmap=1024
set msgsys:msginfo_msgmax=32768
set msgsys:msginfo_msgmnb=65535
set msgsys:msginfo_msgmni=1024
set msgsys:msginfo_msgssz=2048
set msgsys:msginfo_msgtql=1280
set msgsys:msginfo_msgseg=4096

Thanks again!!
Jason


Jason McIntosh
Programmer/Analyst
University of Missouri
573-884-3865
GnuPG Key: http://poetshome.com/pubkey.asc
On Aug 28, 2003, at 11:19 AM, Kevin Buterbaugh wrote:


>>> sunmanagers-bounces@sunmanagers.org wrote on 08/28/2003 09:37:18 AM:
>>>
>>>> I'm working on getting a V880 system running with Oracle 9iR2 on
>>>> Solaris 9.  I've got all (or all the non-contract) patches 
>>>> installed,
>>>> partitions set, etc.  Here's a few questions though:
>>>>
>>>> What kernel settings should I set in /etc/system for such a system?
>>>> I've got 4GB of Ram, and 3 36GB FC-AL harddrives reserved for 
>>>> Oracle.
>>>> This system is ONLY for the Oracle database, and nothing else. 
>>>> Anyone
>>>> have some suggestions on shmmax settings, or something like maxpgio?
>>>> Are these settings even required in Solaris 9?  Are there any other
>>>> tuning options or /etc/system options I should set?  I've got 
>>>> logging
>>>> set on my main partitions, and noatime set on the oracle data
>>>> partitions.  I'm not using both logging and noatime due to the
>>>> corruption bug with that combination.
>>>>
>>>> Are there any other settings I should have set?  Swap size minimum
>>>> recommendations?  I've got a 1GB Swap partition at the moment.  I
>>>> didn't want to create more as I don't think it will be necessary
>>>> considering the load.  If I need to add more swap, can I create a
> swap
>>>> file on one of my existing partitions instead of creating a swap
>>>> partition?  Is there any disadvantage to such a method?
>>>>
>>>> I appreciate any info, and will summarize as always.
>>>> Thanks!
>>>> Jason McIntosh
>>>>
>>>>
>>>> Jason McIntosh
>>>> Programmer/Analyst
>>>> University of Missouri
>>>> 573-884-3865
>>>> GnuPG Key: http://poetshome.com/pubkey.asc
>>>> _______________________________________________
>>>> sunmanagers mailing list
>>>> sunmanagers@sunmanagers.org
>>>> http://www.sunmanagers.org/mailman/listinfo/sunmanagers
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers