Persistance Layer Anaysis shows high percentage

[former_member189420]

Hello Experts,

The PI System is showing high percentage (500 plus) of usage in persistance layer analysis. Recently I encountered queue blockages with TIME_OUT exception as the records were not able to insert in the table SXMSCLUP.

Can anyone tell me should I be worried about so much usage in the persistance layer? However, all the archiving and deletion jobs are running regularly.

Thanks in advance,

Anand Patil

[former_member189420]

SAP Says:

This slow response is probably caused by a bug in Oracle.

Please check and apply the following note:

#1491797 - SLOW INSERT ON LOBS WHEN USING RETENTION AND SBP > 201005

Regards,

Anand Patil

[vadimklimov]

Hello Anand,

What is current setting for Integration Engine's parameter DROP_MAX_TABLE_LOAD?

Please also advise approx. amount of processed messages per day and retention period (you can check SAP Note 872388 for general calculation logic of DROP_MAX_TABLE_LOAD based on these two input parameters).

What is approx. volume of processed messages?

Did you follow the logic described in the mentioned Note (872388) for scheduling archiving/deletion jobs or some other considerations?

In general, persistence layer should be cleaned on regular basis and since you observe exceptions when querying it, the attention for double-checking of current parameters for archiving/deletion jobs vs. persistence layer usage should surely be paid.

My regards,

Vadim