cancel
Showing results for 
Search instead for 
Did you mean: 

DB(Oracle) Performance Issue

Former Member
0 Kudos

Dear Expert,

We have a scenario which has lots of messages coming into XI in parallel, so accordingly we enlarge work process number and receiver queue number. Then we found the bottleneck happens when SAP XI want to insert/update/select information into DB table like XI_AF_MSG/XI_AF_MSG_AUDIT, most of the work processes are waiting/pending on the insert/update/select action. Is there any tuning we can do to improve the performance? Any idea or suggestion is appreciated.

What's more, we have already enlarge the DB(Oracle)'s process/session number, and the JDBC Connector's connection number.

Thanks and Regards,

Nick

Accepted Solutions (0)

Answers (2)

Answers (2)

prateek
Active Contributor
0 Kudos

U should fine tune ur JDBC application with this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/412290ec-0201-0010-0790-dfd946ef...

Use option "Disconnect from Database After Each Message Processing" wherever applicable to ur scenario

Regards,

Prateek

Former Member
0 Kudos

Thanks Prateek,

But we are not using the JDBC Adpater, the message is coming from other adapter like file adapter, and sitting in the SAP XI Receiver queue with a huge number.

Thanks and Regards,

Nick

prateek
Active Contributor
0 Kudos

<i>Then we found the bottleneck happens when SAP XI want to insert/update/select information into DB table like XI_AF_MSG/XI_AF_MSG_AUDIT</i>

How r u achieving this without JDBC?

For handling large messages, the tuning guide would help u

http://help.sap.com/bp_bpmv130/Documentation/Operation/TuningGuide.pdf

Regards,

Prateek

Former Member
0 Kudos

BTW, when the waiting/pending happens, the CPU usage is around 99%.

PS: we have set the work process number as CPU#*4.

Thanks and Regards,

Nick