Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • 276434.1 Modifying the VIP or VIP Hostname of a 10g or 11g Oracle Clusterware Node Oracle
  • OPENING A STANDBY DATABASE IN READ-ONLY MODE Oracle
  • Search and Replace vi editor command. Linux/Unix
  • Another Tuning Article for subheap of shared pool Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • Validating ORACLE_SID againt oratab file. Linux/Unix
  • move_arch_files.ksh Linux/Unix
  • SQLPLUS COPY command Precautions. Oracle
  • Paste command syntax Linux/Unix
  • Identical Dblink Issue… Oracle
  • RMAN : Consistent Backup, Restore and Recovery using RMAN Oracle
  • GSQ.sql Oracle
  • Oracle 10g Installation/Applying Patches Tips Oracle
  • Renaming the column name 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

  • Establishing trusted relationship between dbmonitor( central monitoring) and monitoring targets. Linux/Unix
  • replace alphabets using sed Linux/Unix
  • Removing Ctrl-M from end of line using vi Linux/Unix
  • avail.sh ( find filesystem spae usage) Linux/Unix
  • Adding addidional hard drive and attach it to a linux box. Linux/Unix
  • good linux notes Linux/Unix

Leave a Reply Cancel reply

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

Categories

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

  • 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
  • V$INSTANCE of Oracle in MYSQL24-Jul-2025
  • Day to day MYSQL DBA operations (Compared with Oracle DBA)24-Jul-2025

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Backup and Recovery Scenarios Oracle
  • tuning commmand for cpu, ip and memory stats Linux/Unix
  • Sending email with file attachment. Linux/Unix
  • Search and Replace vi editor command. Linux/Unix
  • Convert multiple rows to single column Oracle
  • Find average Row Length and other table size calculation. metalink notes Oracle
  • How to set Processes Parameter Oracle
  • good linux notes Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme