>From my (OCI) experience, closing a cursor doesn't release the cursor.
Releasing the handle of the statement releases the cursor. Though I'm
not %100 sure why you would be seeing the change if you haven't
changed your code.
On Jun 4, 6:14 am, "Vladimir M. Zakharychev"
<vladimir.zakharyc..._at_gmail.com> wrote:
> On Jun 4, 10:25 am, poschma <marti..._at_utanet.at> wrote:
>
>
>
>
>
> > Hi all!
>
> > After updating our Database from 10.2.0.1 to 10.2.0.3 I get the error
> > Ora-01000 in our application (we use the proC precompiler).
>
> > When I look at the v$open_cursor, I see the number of cursors
> > increasing all the time.
> > In our application we have a lot of select statements and every
> > statement is a cursor. But the cursor is always closed after the
> > statement. And we also have a lot of transactions. And after a
> > rollback the cursors should be closed automatic (am I right?).
>
> > It seams that neither a "EXEC SQL CLOSE ..." nor a "rollback" close
> > the cursors any more!
>
> > The parameter session_cached_cursors is 20, the parameter open_cursors
> > is set to 300.
>
> > With 10.2.0.1 we have no problems.
> > Has anyone an idea whats running wrong? Is there a new parameter?
>
> > Thanks in advance
>
> Afaik, ROLLBACK doesn't close any cursors, it just rolls back current
> transaction (and COMMIT doesn't close cursors either.) Try closing
> unneeded cursors explicitly after rollback. Why you started hitting
> the issue only after patching I can't say. Maybe there's some
> regression in the patchset that causes cursor leakage, but I couldn't
> find any similarly looking bugs on MetaLink except your very own forum
> post...
>
> Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com- Hide quoted text -
>
> - Show quoted text -
Received on Mon Jun 04 2007 - 12:30:10 CDT
