Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Help : ORA-00604 & ORA-01000
You have to find what process in your application is not closing its cursors. Query the v$sqlarea to see what query is showing up a lot. Jim
"AT" <adrianting_at_post1.com> wrote in message
news:3ae0e4b5$1_at_news.starhub.net.sg...
> Hi everyone
>
> I am currently getting the following exception from my Oracle 8i. It seems
> pretty random and although I've increased the open cursor attribute in the
> init file to 200, stopped and restarted the server, it is still occuring
> (but at a lesser frequency).
>
> I've also ensured that all the sql statements are closed appropriately.
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
>
> Is there anyone who faces this similar problem and has found a better
> solution?
>
> Cheers,
> Adrian Ting
>
>
Received on Sat Apr 21 2001 - 10:51:20 CDT