Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Max Open Cursors
Hi,
I’m using implicit cursors and have gotten an ORA-01000: maximum open cursors exceeded.
We are running Oracle 8.0.5
How can I force Oracle to close the open cursors?
What are the trade-offs if I increase the maximum cursors to a larger number (like 2000)?
Thanks,
George Fields
Received on Sat Apr 05 2003 - 11:33:58 CST