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

Home -> Community -> Usenet -> c.d.o.server -> "Ora-01000 maximum open cursors exceeded" after update from 10.2.0.1 to 10.2.0.3

"Ora-01000 maximum open cursors exceeded" after update from 10.2.0.1 to 10.2.0.3

From: poschma <martin_p_at_utanet.at>
Date: Sun, 03 Jun 2007 23:25:09 -0700
Message-ID: <1180938309.031645.234240@q75g2000hsh.googlegroups.com>


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 Received on Mon Jun 04 2007 - 01:25:09 CDT

Original text of this message

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