Relationship Between Common Init.ora Parameters and Unix, Linux Kernel Parameters (Doc ID 144638.1)
Purpose
The following table documents Unix and Linux kernel parameters that should be monitored and possibly increased after changes are made to the related init.ora parameter. Please check with your Operating System documentation for specific details on the parameter changes.
Common Kernel Parameter Definitions
The following Kernel Parameters tend to be generic across most Unix and Linux platforms. However, their names may be different on your platform. Consult your Installation and Configuration Guide (ICG) for the exact names.
maxfiles - Soft file limit per process.
maxuprc - Maximum number of simultaneous user processes per userid.
nfile - Maximum number of simultaneously open files systemwide at any given time.
nproc - Maximum number of processes that can exist simultaneously in the system.
shmall - This parameter sets the total amount of shared memory pages that can be used system wide. Hence, shmall should always be at least ceil(shmmax/page_size).
shmmax - The maximum size(in bytes) of a single shared memory segment.
shmmin - The minimum size(in bytes) of a single shared memory segment.
shmmni - The number of shared memory identifiers.
shmseg - The maximum number of shared memory segments that can be attached by a process.
semmns - The number of semaphores in the system.
semmni - The number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any one time.
semmsl - The maximum number of sempahores that can be in one semaphore set. It should be same size as maximum number of Oracle processes.
NOTE:1011658.6 - Shared Memory Requirements On Unix
NOTE:429191.1 - Kernel setup for Solaris 10 and Solaris 11 using project files
NOTE:301830.1 - Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device
NOTE:1008866.6 - How to determine SGA Size (7.x, 8.x, 9.x, 10g)
Note---> This informationmation taken from oracle metalink. all copy rights oracle only.
=======================================================================
Purpose
The following table documents Unix and Linux kernel parameters that should be monitored and possibly increased after changes are made to the related init.ora parameter. Please check with your Operating System documentation for specific details on the parameter changes.
| Init.ora Parameter | Kernel Parameter |
| db_block_buffers | shmmax, shmall |
| db_files (maxdatafiles) | nfile, maxfiles |
| large_pool_size | shmmax, shmall |
| log_buffer | shmmax, shmall |
| processes | nproc, semmsl, semmns |
| shared_pool_size | shmmax, shmall |
Common Kernel Parameter Definitions
The following Kernel Parameters tend to be generic across most Unix and Linux platforms. However, their names may be different on your platform. Consult your Installation and Configuration Guide (ICG) for the exact names.
maxfiles - Soft file limit per process.
maxuprc - Maximum number of simultaneous user processes per userid.
nfile - Maximum number of simultaneously open files systemwide at any given time.
nproc - Maximum number of processes that can exist simultaneously in the system.
shmall - This parameter sets the total amount of shared memory pages that can be used system wide. Hence, shmall should always be at least ceil(shmmax/page_size).
shmmax - The maximum size(in bytes) of a single shared memory segment.
shmmin - The minimum size(in bytes) of a single shared memory segment.
shmmni - The number of shared memory identifiers.
shmseg - The maximum number of shared memory segments that can be attached by a process.
semmns - The number of semaphores in the system.
semmni - The number of semaphore set identifiers in the system; determines the number of semaphore sets that can be created at any one time.
semmsl - The maximum number of sempahores that can be in one semaphore set. It should be same size as maximum number of Oracle processes.
REFERENCES
NOTE:1010913.6 - UNIX CONFIGURATION PARAMETERS: WHERE TO SET SEMAPHORES AND SHARED MEMORYNOTE:1011658.6 - Shared Memory Requirements On Unix
NOTE:429191.1 - Kernel setup for Solaris 10 and Solaris 11 using project files
NOTE:301830.1 - Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device
NOTE:1008866.6 - How to determine SGA Size (7.x, 8.x, 9.x, 10g)
Note---> This informationmation taken from oracle metalink. all copy rights oracle only.
=======================================================================
Comments
Post a Comment
Oracle DBA Information