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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Help : ORA-00604 & ORA-01000

Re: Help : ORA-00604 & ORA-01000

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Sat, 21 Apr 2001 15:51:20 GMT
Message-ID: <Y%hE6.38201$xN4.2823722@news1.sttls1.wa.home.com>

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

Original text of this message

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