Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Jan 05, 2012 at 06:49 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 05, 2012 at 02:46 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 05, 2012 at 02:47 AM

    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%.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.