Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • When to rebuld B-tree index Oracle
  • telnet listening Linux/Unix
  • proper cpu stats Linux/Unix
  • Process Map for CPU and Memory for OS processes Linux/Unix
  • Gather Stats manually using DBMS_STATS after disabling DBMS_SCHEDULER jobs as previous entry Oracle
  • pvm_metric.sql for gathering report from vmstat tables Oracle
  • Good Oracle Architecture In Short and point to point Oracle
  • remove archfiles only when it is applied to DR rm_archfiles.sh Linux/Unix
  • v$backup.status information Oracle
  • oradebug ipcrm ipcs Oracle
  • Another Tuning Article for subheap of shared pool Oracle
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • Check Oracle installed products using one command Oracle
  • pvm_pre_change.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

  • Oracle 11g Environment Setup Oracle
  • How To Limit The Access To The Database So That Only One User Per Schema Are Connected (One Concurrent User Per Schema) Oracle
  • OEM-troubleshooting on 20-MAY-08 Oracle
  • How do I get Oracle to automatically start when my server boots up? Oracle
  • Drop database in Oracle 10g Oracle
  • Oracle GoldenGate lag monitoring shell script 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 (387)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (336)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Add new columns in dataframe30-Sep-2023

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • How to find pinned objects from shared pool. (pinned via dbms_shared_pool.keep) Oracle
  • Find Stale DR Physical Standby Oracle
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • Oracle Release Explaination Oracle
  • When to rebuld B-tree index Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • CPU speed on Linux Linux/Unix
  • Find Command Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme