与oracle有关的HPUX内核参数.docx

1、与oracle有关的HPUX内核参数 Last Update: July 2002 (Oracle 8/8i/9i R1/9i R2, HP-UX 11/11i)Oracle 9i recommendations:- Minimum RAM = 256 MB- HP-UX 11 or HP-UX 11i- Swap Space: Minimum 2 x RAM or 400MB, whichever is greater- available Disk Space: 3 GB- Create OS UNIX groups for Oracle system:o OSDBA group : Re

2、quiredo OSOPER group: Optionalo ORAINVENTORY group: Optionalo APACHE group: Recommended- Please check appendix 6 for SCHED_NOAGE usage and MLOCKNote: These are minimum kernel requirements for Oracle9i. If you have previouslytuned your kernel parameters to levels equal to or higher than these values

3、(be careful for file system cache parameters dbc_max_pct, dbc_min_pct), continue to use the higher values. A system restart is necessary for kernel changes to take effect.Kernel Parameter Setting PurposeHP-UX 11.x Kernel ParameterDescription, Default/Recommended ValuebufpagesNumber of static Buffer

4、Pages of 4kB, enables dynamic buffer cache (see dbc_max/min_pct). default= 0recommended: 0dbc_max_pctMax dynamic Buffer Cache size in percentof system memory, when bufpages andnbuf are both set to 0, default=50.recommended: between 3 and 10Its more efficient to use system memoryfor Oracle SGA instea

5、d of file systembuffer cachedbc_min_pctMin dynamic Buffer Cache size in percentof system memory (see dbc_max_pct),default=5.recommended: between 2 and 5fs_asyncsee appendix 2 and appendix 6KSI_ALLOC_MAX (NPROC * 8) Defines the system wide limit of queued signal that can be allocated.max_async_portsM

6、aximum number of asyncdsk ports that can be open at one time. If an error happens with this, it will not shown in the Oracle alert.log file or in trace files. default: 50recommended: max. no of shadow processes + no of parallel querie slavesmax_thread_procMax no. of threads allowed in each processde

7、fault: 64recommended: = Oracle 8.1.7 = 256maxfilesSoft File Limit per Process, soft limit for number of files a process is allowed to have open simultaneously. Processes can increase their soft limit until they reach the hard limit maxfiles_lim.default=60.recommended=1024maxfiles_limHard File Limit

8、per Process,default=1024.recommended=1024 (default).maxdsizRefers to the maximum data segment size for 32-bit systems. Setting this value too low may cause the processes to run out of memory.Max Data Segment Size (Bytes)default: 67108864recommended: = Oracle 9i = 1073741824 bytesmaxdsiz_64bitRefers

9、to the maximum data segment size for 64-bit systems. Setting this value too low may cause the processes to run out of memory.Max Data Segment Size (Bytes)default: 1073741824recommended:= Oracle 9i = 2147483648 bytesMAXSSIZDefines the maximum stack segment size in bytes for 32-bit systems.Recommended

10、:= Oracle 9i = 134217728 bytesMAXSSIZ_64BITDefines the maximum stack segment size in bytes for 64-bit systems.Recommended:= Oracle 9i = 1073741824 bytesmaxtsizeMax Text Segment size (Bytes)Recommended: 128MBmax_fcp_reqsMaximum Number of Concurrent Fiber Channel Requests Per Adapterrecommended: 512ma

11、xswapchunksmaximum number of swap chunks where SWCHUNK is the swap chunk size (1 KB blocks).Default: 2048recommended: = Oracle 9i = 16384maxusersValue of MAXUSERS macro, limits theSsstem resource allocation (not the actualnumber of users). Influences nproc, ninode, nfile.default=32.recommended: set

12、to number of concurrent Oracle DB users + 64maxuprcMax Number of simultaneous user processes (per user-id!). default=75Because all database processes often runwith the Oracle user-id, its recommended: = Oracle 9i = (NPROC*9)/10)MaxvgsMax. number of volume groups:Default: 10Recommended: increase to t

13、he number of volume groups you would like to have on the system (maximum 256)MSGMAPDefines the maximum number of message map entries.Recommended:= Oracle 9i = (MSGTQL + 2)MSGMNIDefines the number of message queueidentifiers.Recommended:= Oracle 9i = (NPROC)MSGSEGDefines the number of segments availa

14、ble for messages.Recommended:= Oracle 9i = (NPROC * 4) (at least 32767)MSGTQLDefines the number of message headers.Recommended: = Oracle 9i = (NPROC)NCALLOUTDefines the maximum number of pending timeouts.Recommended:= Oracle 9i = (NPROC + 16)NCSIZEDefines the Directory Name Lookup Cache (DNLC) space

15、 needed for inodes.Recommended:= Oracle 9i = (8 * NPROC + 2048) + VX_NCSIZE)VX_NCSIZE is by default 1024.nfileMax Number of simultaneously Openfiles system-wide at any given time. Totalnumber of slots it the file descriptor table,default=16*(nproc+16+maxusers)/10+32+ 2*(npty+nstrpty)recommended:= Or

16、acle 9i = (15 * NPROC + 2048)nflocksMax Number of File Locks availablesystem-wide, (check with glance if you are getting close to the value you have set)default=200 or 200+10*(num_clients)recommended: = Oracle 9i = (nproc) (at least 4096)NINODEDefines the maximum number of open inodes.Recommended:=

17、Oracle 9i = (8 * NPROC + 2048)NKTHREADDefines the maximum number of kernel threads supported by the system.Recommended: = Oracle 9i = (NPROC * 7) / 4) + 16)nprocMax Number of Processes that can existsimultaneously in the system,default=(20+8*MAXUSERS), influences ninode, nfile.recommended: = Oracle

18、9i = 4096nptyNumber of ptys (pseudo ttys), default=60.recommended: if you are using rlogin/telnetconnections from clients to server thenincrease npty up to the number of clientusers, otherwise use default.Note: ptys are not used when using Oracle SQL*Netnum_tachyon_adaptersHP-UX 11.0 onlyNumber of T

19、achyon-based Fiber Channel Adapters in the SystemRecommended: minimum 5, set to real number of Fiber Channel AdaptersHP-UX 11i no support for tachyon adapters, the new is tachlite, which do not use this kernel parameter.o_sync_is_o_dsyncEnable/Disable translation of O_SYNC toO_DSYNC in open()/fcntl(

20、) calls,default=0.recommended:= Oracle7.3 = use default for o_sync_is_o_dsync=0 (patch #310042 not needed).SEMMAPDefines the maximum number ofsemaphore map entries. Recommended: = Oracle 9i = (SEMMNI + 2)semmniNumber of Semaphore Identifiers,specifies the maximum number of sets ofsemaphores that can

21、 exist simultaneouslyon the system, default=64.recommended: = Oracle9i = 4096semmnsMax Number of Semaphores, defines thesystem-wide maximum number ofindividual semaphores that can beallocated for users, default=128.recommended: = Oracle 9i = (semmni * 2)SEMMNUDefines the number of semaphore undostru

22、ctures.Recommended: = Oracle 9i = (NPROC 4)SEMVMXMaximum value of a semaphore.Recommended: = Oracle 9i = 32768shmmax (see appendix 4)maximum allowable size of one shared memory segment. The SHMMAX setting should be largeenough to hold the entire SGA in one shared memory segment. A low setting can ca

23、use creation of multiple shared memory segments which may lead to performance degradation, but normally it is ok to use a small number of shared memory segments.default=0x04000000 (64MB) Oracle 7 0x40000000 (1GB = 1073741824 Bytes) Oracle 8, 8irecommended: db_block_size * db_block_buffers + shared_p

24、ool_size + log_buffer + shared memory for the application orhold the entire SGA in one shared memory segment !(for 64bit use up to size of physical memory, but Oracle can also use multiple segments (please check appendix 4)Shmmnimaximum number of shared memory segments in the entire system.default=2

25、00. recommended: = Oracle 9i = 512Shmsegmaximum number of shared memory segments one process can attach.default=12.recommended: = Oracle 9i = 32 per Oracle database StreampipesSet this parameter to 0 during on the installation of Oracle DB will reduce the installation time.Default: 0Recommended for

26、installation: 0swapmem_on(see appendix 5)Allow Memory to Exceed Swap Spacedefault: 0 (off)recommended: 1 (on)SwchunkSwap Chunk Size (1K Blocks)default: 2048recommended: 4096VPS_CEILINGmaximum System-Selected Page Size in kilobytes.Recommended: = Oracle9i = 64Helpful Tools:To list all kernel paramete

27、rs on the system - use SAM or - /usr/sbim/kmtune l | moreTo update a kernel parameter - Use SAM or- /usr/sbin/kmtune s =|+To find out 32 or 64 bit HP-UX 11.x getconf KERNEL_BITSLimitations on processes- ulimit aThe command sysdef analyzes the currently running system and reports on its tunable confi

28、guration parameters.- sysdef | moreTo find out 32 or 64 bit Oracle software version $ cd $ORACLE_HOME/bin $ file oracle # if this is the answer, you have 32-bit Oracle oracle: PA-RISC1.1 shared executable dynamically linked -not stripped # if this is the answer, you have 64 bit Oracle oracle: ELF-64

29、 executable object file - PA-RISC 2.0 (LP64)APPENDIX 1: db_block_sizeThe default db_block_size on HP-UX is 2048. But we recommend to use the following values: - db_block_size = 4096 to 8192 for OLTP Applications, - db_block_size = 8192 to 16384 for DSS/DW Applications.APPENDIX 2: Raw Devices + Asynchronous IOWe recom