Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • backspace in SQL Plus not working then..? Linux/Unix
  • Checking SQL Server Version SQL Server
  • Logic to chech # of parameters command line parameters Linux/Unix
  • scp with ssh2 Linux/Unix
  • Space padding in korn shell Linux/Unix
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • ORA-3136 Oracle
  • The most important Tuning Notes Oracle
  • sess1.sql Oracle
  • setting prompt display with .profile Linux/Unix
  • Rman Notes -1 Oracle
  • All Hints for Oracle Databases Oracle
  • Oracle Internal Good Websites 1 Oracle
  • For Search and replace unix command. Linux/Unix
  • How To Transfer Passwords Between Databases (ref note: 199582.1) 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

  • Check_recovery.sh program to run sqlplus and return its values remotely. Linux/Unix
  • Changing default shell Linux/Unix
  • Removing first line Linux/Unix
  • tar and untar a dolder with all its subfolder. Linux/Unix
  • Running select from V$ views from remote server Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (0)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (342)
  • SQL Server (6)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • Trace a SQL session from another session using ORADEBUG30-Sep-2025
  • SQL Server Vs Oracle Architecture difference25-Jul-2025
  • SQL Server: How to see historical transactions25-Jul-2025
  • SQL Server: How to see current transactions or requests25-Jul-2025
  • T-SQL Vs PL/SQL Syntax25-Jul-2025
  • Check SQL Server edition25-Jul-2025
  • Checking SQL Server Version25-Jul-2025
  • Oracle vs MYSQL Architecture differences (For DBAs)24-Jul-2025
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Ports used by Oracle Software Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • DETERMINING WHICH INSTANCE OWNS WHICH SHARED MEMORY & SEMAPHORE SEGMENTS Oracle
  • tab.sql Oracle
  • First Entry in RAC Oracle
  • crontab syntax Linux/Unix
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • OEM-troubleshooting on 20-MAY-08 Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme