From: Krishnamurthy Chandrasekhar (krishnamurthychandrasekhar304@hotmail.com)
Date: Mon May 12 2003 - 09:38:18 EDT
My original question
>
>rp8410 system, 12 CPU, 16 GB memory
>
>Looked through the archives, which has some discussions, but it is not
>clear whether they are valid for this configuration.
>
>We set up the kernel parameters as per the Oracle install guide, but
>had to make repeated changes after Oracle issues. I am looking for
>either a white paper or your suggestions on exactly what to set the
>kernel parameters to.
>
>Only one instance of Oracle will be running.
>
>KC/-
- - - - -
Many thanks to Stuart Abramson, Alex Vinson and David Totsch.
Inspite of lack of detail in my original question, I got exactly
what I was looking for, some example sysdef outputs. Obviously
their use depends upon system configuration, application usage,
HP-UX version, Oracle version and so on ...
We are just starting up and will after some time, collect
performance data and change various parameters as needed.
I just wanted to get past the default parameters that HP-UX
comes with, so that Oracle would run.
I have extracted the portion of the replies that provide the
kernel parameters. Please use carefully, as these may or may
not be relevant in your environment.
KC/-
- - - - -
example 1
>* Tunable parameters
>
>STRMSGSZ 65535
>create_fastlinks 1
>dbc_max_pct 10
>dbc_min_pct 10
>default_disk_ir 1
>dnlc_hash_locks 512
>eqmemsize 128
>executable_stack 0
>max_async_ports 1024
>maxdsiz 0X80000000
>maxdsiz_64bit 0X80000000
>maxfiles 2000
>maxfiles_lim 2048
>maxssiz 0X10000000
>maxssiz_64bit 0X40000000
>maxswapchunks 16384
>maxtsiz 0X10000000
>maxtsiz_64bit 0X40000000
>maxuprc 5100
>maxvgs 99
>msgmap 5122
>msgmni 5120
>msgseg 20480
>msgtql 5120
>ncsize 44032
>nfile 78848
>nflocks 5120
>ninode 43008
>nproc 5120
>nstrpty 60
>nswapdev 25
>scsi_max_qdepth 32
>semmap 10242
>semmni 10240
>semmns 20480
>semmnu 4096
>semmsl 8192
>shmmax 2147483648
>shmmni 1024
>shmseg 256
>swapmem_on 0
>timezone 480
>unlockable_mem 1
>vps_ceiling 64
>
- - - - -
Example 2
>
> Parameter Value Comment
>(remove this 3rd field)
> STRMSGSZ 65535
> bufpages 0
> dbc_max_pct 10
> maxdsiz 671088640
> maxdsiz_64 17179869184 0x00000000400000000
> maxfiles 2048
> maxfiles_lim 2048
> maxswapchunks 5006
> maxuprc ((NPROC*9)/10) 100
> maxusers 200
> maxvgs 80
> msgmap (MSGTQL+2)
> msgmax 32768
> msgmnb 65535
> msgmni (NPROC)
> msgseg 32676
> msgssz 128
> msgtql (NPROC*10) 2046
> nfile (15*NPROC+2048) 8192
> nflocks (NPROC) 400
> ninode 8192
> nproc ((MAXUSERS*3)+64)
> nstrpty 60
> nstrtel (MAXUSERS)
> nswapdev 25
> num_tachyon_adapters 5
> semmni (NPROC*5)
> semmns (SEMMNI*2)
> semmnu (SEMMNI/2)
> semume 64
> semvmx 32768
> shmmax 2147483648
> shmmni 512
> shmseg 32 120
> swapmem_on 0
> timeslice 1
> unlockable_mem (MAXUSERS*10)
>
_________________________________________________________________
Want to get married? Try online matrimony.
http://server1.msn.co.in/features/onlinematrimony/index.asp It's cool.
--
---> Please post QUESTIONS and SUMMARIES only!! <---
To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
Name: hpux-admin@dutchworks.nl Owner: owner-hpux-admin@dutchworks.nl
Archives: ftp.dutchworks.nl:/pub/digests/hpux-admin (FTP, browse only)
http://www.dutchworks.nl/htbin/hpsysadmin (Web, browse & search)
This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:29 EDT