SAP ECC 6.0 system performance recommended parameters required

[Former Member]

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

[Reagan · Accepted solution]

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

[AtulKumarJain]

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,

[Former Member]

Dear all supporters,

I run out the report RSORADJV as per note 1171650, i got recommanded parameters.

Where i will get values for that parameters?

How can i set that values?

"ok (is not set; mentioned with other prerequisites/not mentioned in note) " What does it mean?

"ok (is not set; mentioned with other prerequisites/not mentioned in note)"

"ok (ignored dynamically changed parameter)"

Thanks,

V Srinivasan

[boobboo]

I am very concerned for your customer at the minute, because you obviously need to do lots more studying on Oracle databases. I am not saying this to be mean or nasty, because at least you are asking question which is a good thing - but you should not be left to do this on your own when you obviously have so little experience. At the minute you are actively dangerous with regard to this system, please go an find an Oracle DBA either within your client or your own organisation and engage their help to set these parameters.

Thanks

Chris

[Reagan]

Hello

First read the SAP note which I have mentioned before then you will understand the output of this script.

The note clearly states what parameters are required and with the expected values.

Again, could you tell me the reason as to why you doing the system tuning ?

If there is a performance problem then be specific.

Regards

RB

[Former Member]

Hi Experts,

What is ISspecified & Ordinal values?

[former_member188883]

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

[Former Member]

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.