Re: limitation of CURSORs

It sounds to me like he's implying that the open_cursors is set at a reasonable
level, he just opened too many, and now what does he do... ??

Johannes Wilhelm wrote:

> Nandakumar <nanban_at_my-deja.com> wrote:
> > It looks like, i opened many dynamic cursors from within a procedure
> > and didn't close them in the end. And now, i am at a level
> > where i can't open any more cursors. How could i close these
> > cursors so that further cursors can be opened.
>
> > There should be some DICT table that records the status of cursors with
> > cursor ids, i guess.
>
> > Would appreciate any solution to this probelm.
>
> > Thanks
>
> > In article <7o564l$bff$1_at_nnrp1.deja.com>,
> > Nandakumar <nanban_at_my-deja.com> wrote:
> >>
> >>
> >> 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.
> >>
>
> > --
> > 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.
>
> Add:
> open_cursors = #
> to the init.ora file with #>64 .
>
> Every access to a table or joined table lets an open cursor to your
> session. If you need more than the default of 64 you can enlarge the
> number without problems.
>
> Johannes
Received on Sat Aug 07 1999 - 20:23:19 CDT