Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

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.

Error Messages

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.

Root Cause

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 environment.  This requires the implementation of Oracle standard fixes:

- BUG 18384537
- BUG 16090440

Published May 14, 2016 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us