Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • cp_filesystem.sql Oracle
  • how to find OS block size Oracle
  • To see mem usage and CPU usage system wide. Linux/Unix
  • currwait.sql Oracle
  • How to specify 2 arch location to avoid any kind of DB hanging. Oracle
  • replace alphabets using sed Linux/Unix
  • UTL_FILE test program Oracle
  • Changing default shell Linux/Unix
  • DB Console Mainenance. Oracle
  • set_env_dba Linux/Unix
  • grep multuple patterns Linux/Unix
  • standard Monitoring – 1 Oracle
  • Important Script Method for tuning Oracle
  • longtx.sql Oracle
  • Oracle 11g RAC on OEL 5 and Vmware 2 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

  • To find explain plan for a statement that occurred in past. Oracle
  • To check whether standby is recovering properly or not?? Oracle
  • logminer and my_lbu Oracle
  • refre.sql Oracle
  • Benefits and Usage of RMAN with Standby Databases Oracle
  • good note for shared pool tunnig Oracle

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
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Library cahe Latches and internal explaination Oracle
  • how to find OS block size Oracle
  • Implementation of key based authentications Linux/Unix
  • Generate SSH without password authentication. Linux/Unix
  • fuser to check who is using diretory Linux/Unix
  • Metalink Note: Note:250655.1 : ADDM Basics USING THE AUTOMATIC DATABASE DIAGNOSTIC MONITOR Oracle
  • Wait time tuning research Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme