Home » SQL & PL/SQL » SQL & PL/SQL » How to increase the number of cursors?
How to increase the number of cursors? [message #7718] Wed, 02 July 2003 21:16 Go to next message
Mohamed Amin
Messages: 1
Registered: July 2003
Junior Member
Hi,

I got the error: ORA-01000: maximum open cursors exceeded. How to increase the no. of open cursors in the oracle?

Thanks in advance.

regards,
Amin

Report message to a moderator

Re: How to increase the number of cursors? [message #7733 is a reply to message #7718] Thu, 03 July 2003 06:24 Go to previous message
Deepa
Messages: 269
Registered: November 2000
Senior Member
hi in the init.ora file

increase the number
"open_cursors "

restart the db

Report message to a moderator

Previous Topic: top 5 clients
Next Topic: UPDATE-Clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 13:45:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.