How Kernel Parameters values calculated in 10g*
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: How Kernel Parameters values calculated in 10g*

  1. #1
    Join Date
    Nov 2012
    Posts
    1

    Red face How Kernel Parameters values calculated in 10g*

    Hi to all ;

    Kernal values formula for oracle 10g database on OEL4

    I asked many DBAs regarding this question. Few persons saying right,
    MAny peoples saying it's wrong. Given formula is right or not


    There are two main components

    Shared memory : SHMMAX , this should be more than the size of your memory structures.

    e
    PHP Code:
    gSHMMAX = (SGA+PGA)Instance size  of all the database 30of the instance size.

     
    eg. If i have 3 databases  and sizes are
        
    For DB1 SGA=3G PGA=2G
        
    For DB2 SGA=1G PGA=3G
        
    For DB3 SGA=1G PGA=1G
    So 
    SHMMAX will be (3+2+1+3+1+1)= 11G 30%(11G)=round(11G+3.3)= 15G
    Semaphores : As a DBA we don't know how many users will be accessing one database concurrently.
    we need to get the approximate value from client. This can be calculated using

    PHP Code:
    Semaphores  = (processes of all DB ie.processes parameter from DB)*+10*no.of databases
    eg
    . If i have 3 databases   with processes parameter 
    For DB1 800 DB2=1200,DB3=500
    (800+1200+500)*2+10*2500+30=2530 

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,445

    Cool

    Why not just follow the instructions in the "2.6 Configuring Kernel Parameters" chapter of the fine OracleŽ Database Installation Guide?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,975
    Quote Originally Posted by LKBrwn_DBA View Post
    Why not just follow the instructions in the "2.6 Configuring Kernel Parameters" chapter of the fine OracleŽ Database Installation Guide?
    It's like you want to take the mystery out of the whole process...
    Whatever happened to guesswork?!?!?!?!
    this space intentionally left blank

  4. #4
    Join Date
    Dec 2012
    Posts
    1
    Hi,
    I need to know how to connect database from one server to another server i am new to this explain with details

  5. #5
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by aarif View Post
    I need to know how to connect database from one server to another server i am new to this explain with details
    Firstly, please do not hijack a thread - open a new one if you have a new question.

    Having said that, research DBLINK
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

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



Click Here to Expand Forum to Full Width