Skip to main content

To prevent the dreaded ORA-01000 error, would it be possible to add a cursor mode to Oracle plugin ?

 

Some doc here: https://www.rshankar.com/how-to-find-out-maximum-open-cursors-and-no-of-cursors-open-in-oracle/

 

Thx

Hello :)

If I understand correctly, this mode would monitor the following metrics:
- maximum number of cursors allowed per session
- cursors currently open in your session
- cursors usage by session

with thresholds on the number of cursors open in your session and thresholds on cursors used in each session?

Kind regards


NewDiscussion ongoing

@Jean-François Rameau can you please detail your need as requested by ​@ltirand ?