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,480

    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
    4,021
    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