Skip to Content
avatar image
Former Member

Add memory

Hi all,

we have 16GB RAM in a server HPUX 11.11 SAP R3 Enterprise 4.70 2.00 / Oracle 9i and we want to add another 16GB

what are the correct settings profiles SAP and Oracle that has to change when you add another 16GB of RAM

Thanks

AK

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 16, 2009 at 09:21 PM

    This will depend on how much memory you want Oracle to use and if the rest will be used by SAP... there is not a rule of thumb for this. If you have performance problems in DB then more memory should go to RDBMS, do you need more workprocesses? then you need to increase memory for that, you could probably add more memory for Table buffer but it is not wise to add just for adding because it could create a downgrade in performance instead.

    Why not just ask for a SAP Service or use an early watch so you could get a better idea on where are the performance bottlenecks?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Kim,

      from Database perspective you should consider DB_BLOCK_BUFFERS or DB_CACHESIZE (as of Oracle 9i, alternative to DB_BLOCK_BUFFERS) and SHARED_POOL_SIZE.

      SAP will have many parameters major one would be extended memory parameters, buffer size and no of work process. It depends on many factors like SAP application installed, number of users, OS and DB requirements.

      Thank You,

      Praveen Gudipudi

  • avatar image
    Former Member
    Apr 15, 2009 at 04:24 PM

    I think this note is what you are looking for

    Note 124361 - Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 15, 2009 at 08:47 PM

    In SAP, you may want to change profile parameter em/initial_size_mb.

    Add comment
    10|10000 characters needed characters exceeded