Question
Amazon.com
Amazon.com
US
Amazon.com
Posted: Nov 21, 2017
Last activity: Nov 21, 2017
Last activity: 21 Nov 2017 21:29 EST
Closed
ORA-01000: maximum open cursors exceeded
ORA-01000: maximum open cursors exceeded
Max Cursors are 300 and open cursors are 300 which is causing to occur this issue.
How to resolve it ?
we are Using OJDBC 6
***Edited by Moderator Marissa to update categories***
Posted: 7 years ago
Pegasystems Inc.
US
1. What version of PRPC are you seeing this?
2. Can you paste the complete Exception Stack including the Caused by from the server log file?
Posted: 7 years ago
PEGA
Pegasystems Inc.
IN
Hi SivaKumar,
You need to increase the limit if required ALTER SYSTEM SET open_cursors = 400 SCOPE=BOTH;
But it would be better to understand under what circumstance or scenario you get this.
Regards,
Ujjwal