Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • oradebug ipcrm ipcs Oracle
  • .profile Linux/Unix
  • How to Decide upto what level you can decrement your datafile size. ( Shrink Datafile) Oracle
  • checking redhat linux version Linux/Unix
  • Sending email with file attachment. Linux/Unix
  • Facts about SCN and Rollback Segment Oracle
  • chk_space_SID.ksh Linux/Unix
  • Temporary Tablespace Information and restriction. Oracle
  • Find execution plan from dba_hist_sql_plan for a specific SQL_ID and PLAN_HASH_VALUE fplan.sql Oracle
  • on IBM-AIX for display Linux/Unix
  • find_idle_cpu.sql Oracle
  • Recovering lost SYS password Oracle
  • findinfo.sql (SQL for getting CPU and Active session info) Oracle
  • Some useful Unix Commands Linux/Unix
  • Mutating Table Error while using database trigger Oracle

Kernel Parameter setting explaination for Processes Parameter

Posted on 31-Aug-2006 By Admin No Comments on Kernel Parameter setting explaination for Processes Parameter

SHMMAX = The maximum size(in bytes) of a single shared memory segment.

SHMMIN = The minimum size(in bytes) of a single shared memory segment.

The above settings let the max be bigger then we wil ever use and the min much smaller. They are sufficient for pretty much all systems.

SHMMNI = The number of shared memory identifiers.

SHMSEG = The maximum number of shared memory segments that can be attached by a process.

The above settings should also be sufficient.

SEMMNS = The number of semaphores in the system.

Set to the sum of the PROCESSES parameter for each Oracle database the

largest one, plus 2 times the largest PROCESSES value, plus 10 number of Oracle

databases. For example, consider a system that has three Oracle instances with

the PROCESSES parameter in their initsid.ora files set to the following values:

ORACLE_SID=A, PROCESSES=100

ORACLE_SID=B, PROCESSES=100

ORACLE_SID=C, PROCESSES=200

The value of SEMMNS is calculated as follows:

SEMMNS = ((A=100) + (B=100)) + ((C=200) * 2) +

((# of instances=3) * 10) = 630

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

(The PROCESSES parameter in the init.ora file).

Set to 10 plus the largest initsid.ora PROCESSES parameter of an Oracle

database on the system. The PROCESSES parameter can be found in each

initsid.ora file, loc ORACLE_HOME/dbs directory. The default value of PROCESSES

for the 8.1.5 prebuilt database is 50.

Linux/Unix, shell

Post navigation

Previous Post: sbind.sql Find Bind variable from sql_id sqlid
Next Post: Renaming Global Name GLOBAL_NAME

Related Posts

  • CPU speed on Linux Linux/Unix
  • oracle 10g on linux Linux/Unix
  • grep multuple patterns Linux/Unix
  • Find total file sizes Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • Monitor and Trace Unix processes using truss 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
  • Order by with ROWNUM Oracle
  • find_du.ksh to find # of files, their sizes in current folder and its subdolder Linux/Unix
  • Disbaling DBA_SCHEDULER_JOBS Oracle
  • Creating never expiring DB user accounts in Oracle Oracle
  • More info about /proc folder and its relation with processes. Linux/Unix
  • find_idle_cpu.sql Oracle
  • .profile Linux/Unix
  • avail.sh ( find filesystem spae usage) Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme