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

SAP ECC 6.0 system performance recommended parameters required

Dear Friends,

One of our customer want to tune they SAP environment.

System is migrated from AIX and Oracle 10G to Windows 2008 R2 & Oracle 11G database.

What are the Oracle database parameters we recommended to change the default values.

How to proceed?where need to start Analysis?

Can any one help out to provide solution for this.

Oracle 11.2.0.3

Windows Server 2008 R2 Enterprise 64-bit

Physical Memory 36GB

Swap Memory 20GB

721 EXT Patchlevel 100

Two Instance : (1 SAP instance + 1 Dialog instance)

Thanks in Advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Sep 09, 2013 at 06:12 PM

    Hello

    Check whether the database parameters are set according to this SAP note

    Note 1431798 - Oracle 11.2.0: Database Parameter Settings

    Secondly why is the client asking to tune the system ?

    Is there a performance issue ?

    Regards

    RB

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2013 at 01:25 AM

    Hi Srinivasan,

    As a baseline to begin with you may execute the script attached with below SAP note

    Note 1171650 - Automated Oracle DB parameter check

    Set the parameters with the recommended value from the output of the script.

    Once the baseline is ready, you can continue further tuning based on which transaction or scenarios or SAP application you want to tune.

    Hope this helps.

    Regards,

    Deepak Kori

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 09, 2013 at 03:54 PM

    There's so much more information needed before anyone here could start to help you. Starting with why you feel the need to tune the system in the first place.

    If you honestly don't know where to start, I would suggest you find somebody to speak to that has experience of system tuning. A couple of days with an experienced NetWeaver consultant analysing the system and providing recommendations could save you a huge amount of grief compared to going it alone.

    I notice you said "customer". Do you not have somebody in your organisation able to provide this support to them?

    Steve.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 10, 2013 at 04:30 AM

    Hi Sri,

    Not only oracle parameter requird to tune but you need to tune R3 paramter as well.

    Please check below thread

    http://scn.sap.com/thread/3337575

    You will get help to understand it.

    BR

    Aj,

    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.