Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: limitation of CURSORs

Re: limitation of CURSORs

From: Pradhan <empradhan_at_dplus.net>
Date: Mon, 2 Aug 1999 23:13:52 -0400
Message-ID: <g6tp3.277$XS.1515@newsfeed.slurp.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US