Performance Issue in CRM Production

[Former Member]

Dear All,

We are facing some performance issue in CRM Production which is almost a production down situation as portal, daily CRM operations all are affected.

We are facing some lock entries in DB01 which are in hold state/waiting state of different tables not one table.

Due to this we are facing huge amount of performance issues and all the operations are in halt stage and those are severely impacted. Please provide your suggestions.

Thanks and Regards,

Sakshi

[former_member182985]

Hello Sakshi,

Please see the following note for the transactions can be used to analysis the performance issue.

948066 - Performance Analysis: Transactions to use

Also, there is a KBA about the checklist for the Oracle database performance issue.

1817553 - Checklist for performance problems in SAP Oracle Databases

Best regards,

Julin Xin