Re: ORA-01000 - maximum open cursors exceeded

We get this problem when a user is doing a delete on a table row that cascades to many other tables. Since it does not happen very often, we have not gone deeply into the cause other than previous open cursors for that user seem to hang around for a user. Even if that user logs out and back in again, that one user cannot execute the delete statement. Increasing our open cursors value did not help.

We do know the short term cure:

alter system flush shared_pool

works every time.

Chuck Hamilton wrote:
>
> I receive this error from time to time and am not sure what's causing
> it. I tried increasing the default setting from 50 to 100 for the open
> cursors parameter but it still happens, though less frequently.
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
>
> What's causing it and how do I eliminate it?
>
> If a user breaks a query, or if a session get's killed while it's
> running a query; will that leave cursors open indefinitely?
>
> TIA
>
> --
> Chuck Hamilton
> chuckh_at_ix.netcom.com
>
> Never share a foxhole with anyone braver than yourself!
Received on Wed Feb 07 1996 - 00:00:00 CET