Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • shr1.sql for MTS or Shared server configuration Oracle
  • purge_trc.sh 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
  • SAT Mathematics 10 questions and answer at the end. Uncategorized
  • 10g RAC: Troubleshooting CRS Root.sh Problems Oracle
  • set_env_dba Linux/Unix
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • Exadata Basics Oracle
  • Error Handling in Proc Oracle
  • runon_allpdbs_show_conname.sh Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • How to collect CPU usage on Linux using Shell script Linux/Unix
  • Changing default shell Linux/Unix
  • Order by with ROWNUM Oracle
  • Find_planinfo.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

  • Btee and Bitmap Plans in Oracle 9i and higher Oracle
  • Goog notes on X$ tables Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • Processes Parameter decision Oracle
  • before_trunc.sql Before Truncate table needs to execute following: 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 (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 (5)
  • Videos (0)

Recent Posts

  • 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
  • find_arc.sql09-Apr-2026
  • pvm_pre_change.sql08-Apr-2026
  • find_encr_wallet.sql08-Apr-2026
  • find_pdbs.sql08-Apr-2026

Archives

  • 2026
  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • SAN Linux/Unix
  • Database link password in user_db_links Oracle
  • normal maintenance for exp-imp and renaming table Oracle
  • Oracle Connections expire_time and firewall Oracle
  • Export With Query Another Example. Oracle
  • Histogram information Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle

Copyright © 2026 pvmehta.com.

Powered by PressBook News WordPress theme