How to do performance tuning in SRM procurement?

[Former Member]

Our SRM procurement is very slow.

Could you share your experience in tuning SRM procurement?

Thanks!

[Former Member · Accepted solution]

Hi,

Please go throught this .

Rebuild the indexes of the following tables on a regular basis:

ARFCSSTATE

ARFCSDATA

TRFCQOUT

TRFCQIN

TRFCQSTATE

TRFCQDATA

ARFCRSTATE

This will significantly reduce the database load and therefore result in reduced database response times, in

particular for all index accesses against the qRFC tables.

Implementation: See SAP Notes 407125 and 332677 for instructions.

For oracle 8i.

See SAP Note 332677 for advantages and disadvantages of the different methods.

The index rebuild might take up to several minutes for large tables and should be carried out during times

with low RFC traffic.

For oracle 9i or higher

The Size of the tRFC and qRFC Tables can vary for Applications that use this Functionality frequently. For Databases which use a CBO (Cost Based Optimizer) and that do not keep the Database Statistics current incorrect access paths may be chosen. This can lead to very long Runtimes.

Download the pre-generated statistics for the RFC tables TRFCQIN, TRFCQOUT,ARFCSSTATE, ARFCSDATA, ARFCRSTATE, QREFTID, TRFCQDATA, and TRFCQSTATE from SAP Note 1020260 and import them into your Oracle database using the instructions in the SAP Note. Ensure that the statistics are not overwritten by the next run of the BR tools by following the instructions in the SAP Note

Close the post if you are answered.

Regards,

Chetan.