Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: Init.ora Parameters and Unix Kernel

  1. #1
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    Delhi, India, India
    Posts
    128

    Init.ora Parameters and Unix Kernel

    Relationship Between Common Init.ora Parameters and Unix Kernel Parameters

    Purpose

    The following table documents Unix kernel parameters that should be
    monitored and possibly increased after changes are made to the related
    init.ora parameter. Please check with your Operating System documentation
    for specific details on the parameter changes.

    Init.ora Parameter Unix Kernel Parameter
    ------------------------- -------------------------
    sga_max_size - shmmax
    db_cache_size - shmmax
    db_files (maxdatafiles) - nfile, maxfiles
    large_pool_size - shmmax
    log_buffer - shmmax
    processes - nproc, semmsl, semmns
    shared_pool_size - shmmax

    Common Unix Kernel Parameter Definitions

    The following Kernel Parameters tend to be generic across most Unix
    platforms. However, their names may be different on your platform.
    Consult your Installation and Configuration Guide (ICG) for the exact
    names.

    maxfiles - Soft file limit per process.
    maxuprc - Maximum number of simultaneous user processes per userid.
    nfile - Maximum number of simultaneously open files systemwide at any given time.
    nproc - Maximum number of processes that can exist simultaneously in the system.
    shmmax - The maximum size(in bytes) of a single shared memory segment.
    shmmin - The minimum size(in bytes) of a single shared memory segment.
    shmmni - The number of shared memory identifiers.
    shmseg - The maximum number of shared memory segments that can be attached by a process.
    semmns - The number of semaphores in the system.
    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.

    References:

    Note:1010913.6 - Unix Configuration Parameters: Where to set Semaphores and Shared Memory
    Note:1008866.6 - How to determine SGA Size (7.x, 8.0, 8i)
    Note:1012819.6 - Operation System Tuning issues on Unix
    Note:1011658.6 - Shared Memory requirements on Unix
    Last edited by Hemant; 11-04-2011 at 05:57 PM.
    Regards,
    -Amit

  2. #2
    Expert Oracle Administrator
    Join Date
    Oct 2011
    Location
    New Delhi, India
    Posts
    427
    Thanks for this very helpful post Amit , to keep in mind the checks that need to be done on the OS side , prior to modifications to the init parameters.

+ Reply to Thread

Similar Threads

  1. UNIX Profile (ORACLE APPS DBA)
    By Jitendra in forum OS for Oracle Administration
    Replies: 2
    Last Post: 06-12-2013, 06:37 PM
  2. How to share between window to unix?
    By deepak in forum OS for Oracle Administration
    Replies: 2
    Last Post: 01-25-2012, 02:39 PM
  3. ASM Instance Init Parameters - Quick View
    By Hemant in forum RAC Installation, ASM Install , ASM Administration
    Replies: 0
    Last Post: 11-21-2011, 03:54 PM
  4. Major Oracle Database Init Parameters 10G
    By Hemant in forum Core Database Administration and Monitoring
    Replies: 0
    Last Post: 11-12-2011, 01:13 PM
  5. DATAPUMP EXCLUDE/INCLUDE parameters
    By Amit in forum Backup, Restoration & Recovery, RMAN, Flashback, Datapump, Export, Import
    Replies: 0
    Last Post: 11-04-2011, 02:22 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics