The default kernel parameter settings for the HP-UX Operating system running Oracle 8.X Enterprise Edition:
Summarizes the requirements for installing Oracle8i on your HP-UX 
system. If your system fails to satisfy any listed requirement, perform 
the tasks listed on page 2-4 of the Oracle8i Installation Guide Release  
3(8.1.7) for HP 9000 Series HP-UXas necessary to configure your system  
to meet these requirements. 
 
UNIX Kernel Parameters: 
======================= 
Shared Memory: 
-------------- 
Use the System Administrator?s Menu (SAM) to configure the HP-UX kernel  
with the minimum recommended values. 
 
SHMMAX 1 GB 
- This setting does not affect how much shared memory is needed or used  
by Oracle8i or the operating system. It is used only to indicate the  
maximum allowable size. This setting also does not impact operating  
system kernel resources. 
SHMMIN 1 
SHMMNI 100 
SHMSEG 10 
 
Semaphores: 
----------- 
SEMMNI 70 
- Set the number of semaphore set identifiers in the system. SEMMNI 
determines the number of semaphore sets which can be created at any one  
time.  The PROCESSES parameter can be found in each initsid.ora file,  
located in the $ORACLE_HOME/dbs directory. The default value of PROCESSES 
for the preconfigured database created by Oracle Database Configuration  
Assistant is 50. 
SEMMNS 200 
- Set the number of semaphores in the system to 200. The default value  
of SEMMNS is 128, which is, in most cases, too low for Oracle. 
 
 

The default kernel parameter settings for the HP-UX Operating system running Oracle 9.X Enterprise Edition:
Oracle9i uses UNIX resources such as shared memory, swap memory and semaphores  
extensively for interprocess communication. If your kernel parameter settings  
are insufficient for Oracle9i, you will experience problems during installation  
and instance startup. The greater the amount of data you can store in memory,  
the faster your database will operate. In addition, by maintaining data in  
memory, the UNIX kernel reduces disk I/O activity.  
 
Use the System Administrator's Menu (SAM) to configure the HP kernel with the  
minimum requirements. Refer to the following table to determine if your system 
shared memory and semaphore kernel parameters are set high enough for Oracle9i.  
 
Use the ipcs command to obtain a list of the system's current shared memory and 
semaphore segments, and their identification number and owner.  
 
The parameters in the following table are the minimum values required to run  
Oracle9i with a single database instance.  
----------------------------------------------------------------------------- 
Kernel Parameter: 
================= 
KSI_ALLOC_MAX=(NPROC * 8)   
- Defines the system wide limit of queued signal that can be allocated.   
MAXDSIZ=1073741824 bytes   
- Refers to the maximum data segment size for 32-bit systems. Setting this value 
too low may cause the processes to run out of memory.   
MAXDSIZ_64=2147483648 bytes   
- Refers to the maximum data segment size for 64-bit systems. Setting this value 
too low may cause the processes to run out of memory.   
MAXSSIZ=134217728 bytes   
- Defines the maximum stack segment size in bytes for 32-bit systems.   
MAXSSIZ_64BIT=1073741824   
- Defines the maximum stack segment size in bytes for 64-bit systems.   
MAXSWAPCHUNKS=(available memory)/2   
- Defines the maximum number of swap chunks where SWCHUNK is the swap chunk size 
(1 KB blocks). SWCHUNK is 2048 by default.   
MAXUPRC=(NPROC + 2)   
- Defines maximum number of user processes.   
MSGMAP=(NPROC + 2)   
- Defines the maximum number of message map entries.   
MSGMNI=NPROC   
- Defines the number of message queue identifiers.   
MSGSEG=(NPROC * 4)   
- Defines the number of segments available for messages.  
MSGTQL=NPROC   
- Defines the number of message headers.  
NCALLOUT=(NPROC + 16)   
- Defines the maximum number of pending timeouts.   
NCSIZE=((8 * NPROC + 2048) + VX_NCSIZE)   
- Defines the Directory Name Lookup Cache (DNLC) space needed for inodes.  
  (VX_NCSIZE is by default 1024.) 
NFILE=(15 * NPROC + 2048)   
- Defines the maximum number of open files.   
NFLOCKS=NPROC   
- Defines the maximum number of files locks available on the system.   
NINODE=(8 * NPROC + 2048)   
- Defines the maximum number of file locks.   
NKTHREAD=(((NPROC * 7) / 4) + 16)   
- Defines the maximum number of kernel threads supported by the system.   
NPROC=4096   
- Defines the maximum number of processes.   
SEMMAP=((NPROC * 2) + 2)   
- Defines the maximum number of semaphore map entries.   
SEMMNI=(NPROC * 2)   
- Defines the maximum number of semaphore sets in the entire system.   
SEMMNS=(NPROC * 2) * 2   
- Sets the number of semaphores in the system. The default value of SEMMNS is 
128, which is, in most cases, too low for Oracle9i software.    
SEMMNU=(NPROC - 4)   
- Defines the number of semaphore undo structures.    
SEMVMX=32768   
- Defines the maximum value of a semaphore.   
SHMMAX=Available physical memory   
- Defines the maximum allowable size of one shared memory segment. The SHMMAX  
setting should be large enough to hold the entire SGA in one shared memory  
segment. A low setting can cause creation of multiple sharedmemory segments  
which may lead to performance degradation.    
SHMMNI=512   
- Defines the maximum number of shared memory segments in the entire system.   
SHMSEG=32   
- Defines the maximum number of shared memory segments one process canattach.   
VPS_CEILING=64   
- Defines the maximum System-Selected Page Size in kilobytes.   
 
Note: These are minimum kernel requirements for Oracle9i. If you have previously 
tuned your kernel parameters to levels equal to or higher than these values,  
continue to use the higher values. A system restart is necessary for kernel  
changes to take effect.