Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Deleting first line and lastline of a file using sed Linux/Unix
  • Oracle Support Metalink ID 161818.1 Oracle
  • prepfiles.sh for step by step generating pending statistics files Oracle
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • Rename Oracle Instance Name Oracle
  • Read CSV File using Python Python/PySpark
  • Generating XML from SQLPLUS Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • Shuffle an array PHP/MYSQL/Wordpress
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • cold backup scripts to copy locally Linux/Unix
  • How to set Processes Parameter Oracle
  • Oracle Material from OTN Oracle
  • Important Solaris Commands Linux/Unix
  • Find_stale_dr.sql finding stale physical DR.. 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

  • More info about /proc folder and its relation with processes. Linux/Unix
  • Deleting first line and lastline of a file using sed Linux/Unix
  • Remove DOS CR/LFs (^M) Linux/Unix
  • Running select from V$ views from remote server Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • Single character replacement in Unix Linux/Unix

Leave a Reply Cancel reply

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

Categories

  • AMC10 (0)
  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (150)
  • MYSQL (5)
  • Oracle (403)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (18)
  • rman-dataguard (26)
  • shell (151)
  • SQL scripts (349)
  • SQL Server (6)
  • Uncategorized (9)
  • Videos (0)

Recent Posts

  • Tutornet.US — Source of excellent learning14-Oct-2026
  • OCI Infrastructure Patching14-Oct-2026
  • Free API credits for AI models14-Oct-2026
  • AMC1020-Sep-2026
  • Key Management in Oracle: The Core Issue: Missing Master Key12-May-2026
  • SAT Mathematics 10 questions and answer at the end.30-Apr-2026
  • top 10 AI news today30-Apr-2026
  • runon_allpdbs_show_conname.sh23-Apr-2026
  • runon_allcdbs_find_pdbs.sh23-Apr-2026
  • Running PDB on single node in RAC09-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • online_bkup.sql Oracle
  • Find All internal Parameters Oracle
  • create database syntax Oracle
  • normal maintenance for exp-imp and renaming table Oracle
  • Jai Shree Ram Oracle
  • move_arch_files.ksh /* Good One */ Linux/Unix
  • Find Multiple levels of object dependencies : depen.sql Oracle
  • Goog notes on X$ tables Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme