Re: v$OPEN_CURSORS

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 31 May 2002 13:13:46 -0700
Message-ID: <ad8lhq01m5m@drn.newsguy.com>

In article <979919aa.0205311133.2b964c41_at_posting.google.com>, snekse_at_hotmail.com says...
>
>Can this table be used to close cursors? We've reached our max limit
>and cannot restart the server.

you hit max open cursors/session. Not per database.

Your applications do not close the cursors (they are "leaking" them). You need to restart your application -- not the database itself. You need to then track down what cursors they are failing to close -- in effect "losing" the handles to and have them close them.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp

Received on Fri May 31 2002 - 15:13:46 CDT