Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Privilege to describe the table. Oracle
  • Oracle10g – Using SQLAccess Advisor (DBMS_ADVISOR) with the Automatic Workload Repository Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • refre.sql Oracle
  • eplan.sql Oracle
  • findx.sql /* Find Indexes on specified USER.TABLE_NAME */ Oracle
  • Sort with ASCII order and Numeric Order Linux/Unix
  • DBMS_STATS Metalinks Notes Oracle
  • How does one overcome the Unix 2 Gig file limit? Linux/Unix
  • block_ident.sql Oracle
  • runsql_once.ksh Linux/Unix
  • Proc code Oracle
  • sbind.sql Find Bind variable from sql_id sqlid Oracle
  • good linux notes Linux/Unix
  • Reading config file from other folder inside class Python/PySpark

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

  • rm_backup_arch_file.ksh Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • copying/removing directory with all its subdirectory Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • How to sort list of files on basis of their sizes. Linux/Unix
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • move_arch_files.ksh Linux/Unix
  • oradebug ipcrm ipcs Oracle
  • _B_TREE_BITMAP_PLANS issue during 8.1.7 to 9.2.0.8 upgrade Oracle
  • Kill a session dynanically using execute immediate Oracle
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • How to check current redo log progress redo_progress.sql Oracle
  • mutex in Oracle 10.2.0.2 or Oracle 10g Oracle
  • get_vmstat_linux Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme