Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • Generating XML from SQLPLUS Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • ENQ: KO – FAST OBJECT CHECKPOINT tips Oracle
  • eplan9i.sql Oracle
  • Useful Solaris Commands on 28-SEP-2005 Linux/Unix
  • DBMS_STATS Metalinks Notes Oracle
  • note id 373303.1 Linux/Unix
  • set_env_dba Linux/Unix
  • DBMS_JOB all example Oracle
  • Oracle Identifiers Oracle
  • Find sort details from Db find_sort.sql Oracle
  • Jai Shree Ram PHP/MYSQL/Wordpress
  • export import with parameter file. Oracle
  • Add new columns in dataframe Python/PySpark
  • currwait.sql Oracle

How to calculate PROCESSES parameter

Posted on 09-May-2008 By Admin No Comments on How to calculate PROCESSES parameter

SEMMSL

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.

SEMMNS

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

Oracle, SQL scripts

Post navigation

Previous Post: How to set Processes Parameter
Next Post: ORA-4031 issue and solution on 09-MAY-2008

Related Posts

  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • Drop specific SQL plan baseline – spm Oracle
  • 556976.1 Oracle Clusterware: Components installed Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Important Script Method for tuning Oracle

Leave a Reply Cancel reply

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

Categories

  • Ansible (0)
  • AWS (2)
  • Azure (1)
  • Django (0)
  • GIT (1)
  • Linux/Unix (149)
  • MYSQL (5)
  • Oracle (393)
  • PHP/MYSQL/Wordpress (10)
  • POSTGRESQL (1)
  • 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

  • Complete Git Tutorial for Beginners25-Dec-2025
  • Postgres DB user and OS user.25-Dec-2025
  • 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

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • To seee semaphores and shared memory segments in Solaris Linux/Unix
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • create trigger syntax Oracle
  • usnsql.sql Displays information about UNDO segments with sql statements Oracle
  • Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1 Oracle
  • On solaris 10, “S” link is not part of $ORACLE_HOME/bin/oracle as default. ( For 9.2.0.8) Oracle
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • Jai Shree Ram Linux/Unix

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme