• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Common Init.ora Parameters and Unix, Linux Kernel Parameters and Relationship Between Them

by admin

Its is important to know the most commonly used parameters in the pfile/spfile and their relationship with the kernel parameters to troubleshoot issues. 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.

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.

  • 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.

Filed Under: Linux, oracle

Some more articles you might also be interested in …

  1. Can’t start X11 applications after “su” or “su -” to another user
  2. Understanding the Network interface configuration file /etc/sysconfig/network-scripts/ifcfg-eth#
  3. What are the .lok files used in WebLogic
  4. UNIX / Linux : Send mail with attachment using mutt
  5. How to recreate the spfile for RAC instances where the spfile is stored in ASM
  6. Mutt, Mail and Telnet – Send mails from linux command line or terminal
  7. UNIX / Linux : What is the correct permission of /tmp and /var/tmp directories
  8. How to relocate the redo log files to a different location on disk
  9. How to Set a Custom Interface Name with NetworkManager in CentOS/RHEL 7
  10. How To Check Current Values for Kernel Tuning Parameters in CentOS/RHEL

You May Also Like

Primary Sidebar

Recent Posts

  • JavaFX ComboBox: Set a value to the combo box
  • Nginx load balancing
  • nginx 504 gateway time-out
  • Images preview with ngx_http_image_filter_module

© 2022 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright