Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: limitation of CURSORs
HI
You can set the cursor limit from init<SID>.ora file and parameter name
is
open_cursors
Usually by default its value is 50. In my system where every applications
logs as a same user we set it up to 400.
Also bounce the database after changing the init<SID>.ora file.
HTH
pradhan
Nandakumar wrote in message <7o564l$bff$1_at_nnrp1.deja.com>...
>
>
>
>When i try to drop a view, i get an error that says maximum CURSOR limit
>has exceeded.
>
>Anyone can give an idea on how this can be reset?
>
>drop view table1
>*
>ERROR at line 1:
>ORA-00604: error occurred at recursive SQL level 1
>ORA-01000: maximum open cursors exceeded
>
>
>Thanks
>--
>Nandakumar
>Systems Analyst
>New York
>(N.Kumar_at_rocketmail.com)
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Aug 02 1999 - 22:13:52 CDT
![]() |
![]() |