I would like to know how many cursors are opened when an appication is running.What is the syntax to check the no of open cursors.Also if there is some open cursors I need to close when the application runs.How to close that
Thanks
Suresh
Printable View
I would like to know how many cursors are opened when an appication is running.What is the syntax to check the no of open cursors.Also if there is some open cursors I need to close when the application runs.How to close that
Thanks
Suresh
Check V$OPEN_CURSOR, it has the cursor each session has open.
Thanks.How to close the cursors if there is any when the application is running.