Slow performing sppr_sys_reservequeueitem_b
A systems administrator observes very poor system performance. An analysis of PegaAES logs reveals that that database performance is very poor, and database is an Oracle 11 implementation.
From the PegaAES logs, the customer reports that the database performance problems are the result of a poorly performing stored procedure - sppr_sys_reservequeueitem_b.
Steps to Reproduce
Unknown. No specific steps were found to trigger this problem. The problem is continuously occurring.
This is a previously identified performance problem in this stored procedure. The root cause is the ORDERBY clause in the SQL string process.
To resolve this issue, the standard stored procedure sppr_sys_reservequeueitem_b is modified. The modification is to alter the ORDERBY clause:
orderby := ' order by pzInsKey ASC';
orderby := ' order by pyMinimumDateTimeForProcessing ASC';
Also, the environment employs the Oracle 220.127.116.11 environment. This requires the implementation of Oracle standard fixes:
- BUG 18384537
- BUG 16090440
0% found this useful