Add memory

[Former Member]

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

[Former Member · Accepted solution]

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?

[Former Member · Accepted solution]

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

[marcelo_sehnem]

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

[Former Member]

I think this note is what you are looking for

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