Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • Find Command Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • get_vmstat_linux Oracle
  • sqlnet.ora paramters Oracle
  • Oracle 11g Training on 29JAN1010 Oracle
  • RAC 11g with vmware Oracle
  • Consolidated Reference List Of Notes For Migration / Upgrade Service Requests -ID 762540.1 Oracle
  • This is im telling Kishore Oracle
  • Sample WW22 listener.ora Oracle
  • process id based files and processes Linux/Unix
  • oracle tips… from http://www.bijoos.com/oracle/douknow.htm Oracle
  • rm_backup_arch_file.ksh Linux/Unix
  • column level grant syntax Oracle

Processes parameter and its dependencies on OS kernel parameters

Posted on 19-Nov-2008 By Admin No Comments on Processes parameter and its dependencies on OS kernel parameters

At this time in 800P, we are having following parameter set.

NAME TYPE VALUE

———————————— ———– ——————————

processes integer 3500

sessions integer 9000

The main parameter is “processes” parameter as it depends upon the # of semaphores in the system.

This parameter depends upon followng kernel values.

nproc – Maximum number of processes that can exist simultaneously in the system

semmsl – The maximum number of sempahores that can be in one semaphore set. It should be same size as maximum number of Oracle processes.

semmns – The number of semaphores in the system.

Now on sunflower1, we are having following parameter set.

sunflower1/800P>cat /etc/system | grep semm

set semsys:seminfo_semmns=0x7631 (This is equivalent to decimal 30263)

set semsys:seminfo_semmsl=5000

I am unable to find nproc kernel parameter on Sunflower1 but Kishore said it will be default to 30K.

So, Conclusion:

The max # of processes supported by current OS configuration = 5000

The max # of processes supported by current db configuraiton = 3500

This will reflect concurrent user+sever processes running on Sunflower1 DB box.

Linux/Unix, shell

Post navigation

Previous Post: Nice Article about semaphores and init.ora Processes parameter relations
Next Post: shutdown linux

Related Posts

  • Jai Shree Ram Linux/Unix
  • CPU Core related projections AWS
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • Changing default shell Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Paste command syntax Linux/Unix

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • login.sql Oracle
  • Building Our Own Namespaces with “Create Context” Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Find long Running Transaction Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • Shuffle an array PHP/MYSQL/Wordpress
  • How to choose Driver table in SQL statement Oracle
  • Which environment is used by currently running process ( Very good) Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme