Re: ORA-00604 error occurred at recursive SQL level num

username wrote:
>
> Costin Rizan wrote:
> >
> > Hello,
> >
> > I'm getting this error in one of my forms once in a while. As far
> > as I can tell this error might have something to do with a table
> > constraint violoation however due to the number of tables involved and
> > the fact that the error does not happen all the time, I am havine trouble
> > pin pointing the problem.
> >
> > Would somebody that has encountered this error before, confirm
> > that this type of error may indeed be a constraint violation and if so,
> > how can I find out which constraint?
> >
> > Thanks!
> >
> > Costin
>
> We encountered this error many times on one of our laptops. We found
> SGA was being exhausted, and cursors were not opening and closing
> properly. We added RAM and bumped up the SGA, the problem went away.
>
> Good Luck.

I've always cleared this up by bumping open_cursors in init.ora But perhaps, by bouncing Oracle, the fragmentation problem clears up, so maybe the fix just seems to work. Except, I never get it again :)

Cheers. Received on Thu Jun 12 1997 - 00:00:00 CEST