memory database parameters for SAP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: memory database parameters for SAP

  1. #1
    Join Date
    Jan 2001
    Posts
    10
    Hello!

    Again I. Now, I want to know any document where explain me the settings of oracle parameters respect to memory for a system SAP R/3. For instance, for the value of db_block_buffers, the shared_pool_size and the log_buffers.

    I am trying setting the parameters for our oracle database to tuning our system.

    Thanks for your help.
    oal

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Configuring SGA depends upon available Physical Memory.
    How much does the machine have?

  3. #3
    Join Date
    Jan 2001
    Posts
    10
    We have 8 GB on the central database instance and we have 3 applications servers. The SAP documentation say me that I must to use the 0.8*RAM for the SGA and the rest for SAP work processes
    oal

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    80 % of RAM for SGA is too big and may not be optimal also. You can start with 2GB and slowly increase so that the HIT Ratio is around 90%. Also remember that RAM is needed for other processes, user sessions and PGA.

  5. #5
    Join Date
    Jan 2001
    Posts
    10
    How can I distribute the 2 GB for all of the SGA?
    oal

  6. #6
    In Oracle ERP would be 1.5 shared pool size and .5 db_block_buffers, but that's because Oracle Apps. use a lot of PL/SQL.
    If this is not your case you can set it the other way .5G shared pool and 1.5 db_block.
    I have been told that log_buffer >=20M doesn't give you any performance.
    Ramon Caballero, DBA, rcaballe@yahoo.com

  7. #7
    Join Date
    Jan 2001
    Posts
    10
    Now, our system is setting as follow:

    db_block_buffers 1073741824 bytes
    log_buffers 1056768 bytes
    shared_pool_size 698351616 bytes
    shared_pool_reserved_size 69206016 bytes



    We donīt use a lot of storage procedures PL/SQL because this is a SAP R/3 system and the procedures that use are programmed on ABAP language.

    I donīt kwon if this is the correct distribution for our SAP R/3 system.
    oal

  8. #8
    There aren't "correct" parameters, so far I see them right.
    You will have to monitor the first days a little harder and don't count the "load days".
    Ramon Caballero, DBA, rcaballe@yahoo.com

  9. #9
    Join Date
    Jan 2001
    Posts
    10

    Talking

    Thanks for your help.

    I will be monitoring the system to catch this information.
    oal

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