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
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
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.