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

Cursor leak: Maximum number of open cursors exceeded



In Production, the PegaRULES logs are presenting a number of open cursors exceeded.
This issue is mainly reproducable in Production due to the volumes.
It is obviously a cursor leak and some
Autonomic Event Services (AES) reports are confirming the leak.

Error Messages

ORA-01000: Maximum number of open cursors exceeded.

Steps to Reproduce

Not applicable.

Root Cause

A cursor leak has multiple root causes. The first one is the setting of "open_cursor", the original value was "300" which is a bit low for a PRPC application so it has been changed to "500" but no significant reduction of cursor leak.
The second one could be an incompatible jar file.
The following article has been used
"" but still not working. The third one is an issue with a store procedure. The following article has been used "", the behaviour was slightly better after this change but still not fully working as expected.

Run the following steps in order to identify which SQL queries were holding the cursor:
  1. Get the list of SQL with high open cursors with this SQL (“SELECT sid, sql_text, hash_value, user_name, COUNT (*) AS "OPEN CURSORS" FROM v$open_cursor WHERE user_name = 'PRPC718' GROUP BY sql_text, sid, user_name ORDER BY 4 DESC”) 
  2. Then to get a fuller view of the SQL text, use a query like (“select vst.hash_value, vst.piece, vst.address, voc.user_name as user_name, vst.sql_text as sqltext from v$open_cursor voc inner join v$sqltext vst on voc.address=vst.address and voc.hash_value=vst.hash_value where voc.user_name='PRPC718' order by vst.hash_value,vst.address,vst.piece;”)
  3. Find the full SQL for the large number of open cursors using the hash_value to match from the first and second queries.
The main responsible query was always the same one: select pzInsKey as "pzInsKey" , pxLockhandle as "pxLockHandle" from OWNER_VZD.pr_sys_locks where pxOwnerID = :1


Apply HFix-25792.


Published April 27, 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