After RAM changes which settings on ORACLE/SAP needs to be done to operate

[Former Member]

Hello

We have a server with 112GB of RAM(on an HP_UX IA64 blade). The system is installed by default (50% to Oracle DB 50% to SAP...) Tommorow we will have to take out 32GB.

Which settings we have to change in order SAP will function best it can (or minimum changes in settings needed in order SAP functiones)

Thank you in advance

[former_member188883 · Accepted solution]

Hi Jon,

As Ratnajit mentioned, following database parameters needs to be adjusted.

db_cache_size

pga_aggregate_target

shared_pool_size

sga_max_size

Post reduction, you can re-verify the parameter values by running the report attached to SAP note 1171650 for oracle 10g.

Additionally post adjusting the work processes in SAP application you need to check whether shared memory segments are correctly configured using the command

sappfpar -check pf=<path of instance profile>

Regards,

Deepak Kori

[former_member189725]

On the Oracle front, you will have to adjust the following parameters :

db_cache_size

pga_aggregate_target

shared_pool_size

sga_max_size

On the SAP front change the following parameters:

em/initial_size_mb

Also check if it is possible to reduce the number of dialog and background workprocesses by 20%.

[Former Member]

Hi,

It depends on your DB size, If you DB size is huge, then you can try to minimize memory tuning for SAP and tune the parameters accordingly. Because database requires more memory for better performance.