Sponsored Links
maximum open cursors exceeded
How to check open cursors and increase it?
if you get maximum open cursors exceeded, you might need to increase open cursors in the database.
This is dynamic parameter,, So you can change it while database is running.
Also it is no harm to increase the open cursors number.
First yo need to get current value.
To get open cursors value
select * from v$parameter where name like 'open_cursors'
Then execute following command
ALTER SYSTEM SET open_cursors = 1500 SCOPE=BOTH
Page 1
|
| 
