how to find out whether a cursor has been closed
Hi, all
I'd like to find out if there are any open_cursors not being closed as of now by viewing data dictionary tables or views. I tried v$sysstat and v$open_cursors without any help. They only show the cursors opened and closed accumulatively.
Any help would be appreciated.
DF
Re: how to find out whether a cursor has been closed
Hi,
The cursors listed in V$OPEN_CURSORS are,in fact, still open.This is a performance optimization method used by the server.Even though you have CLOSED the cursors, they are still cached in Server memory. This is not a bug. The code leaves cursors open and caches them, as intended.The CLOSE_CACHED_OPEN_CURSORS parameter in init.ora forces all of these cached cursors to be closed at the end of each transaction,if that is desired.This parameter is obsolete in Oracle versions 8i and above.
Regards,
Rohit Nirkhe,Oracle/Apps DBA,OCP 8i,9i
oracle-support@indiatimes.com