How do I display leaked cursors
rsubersMar 6 2009 — edited Mar 9 2009I am assisting in troubleshooting a Java/JDBC program that is leaking open cursors (The program runs until the maximum number of cursors is exceeded and then crashes). I am trying to find a way to determine how many cursors the program has open from the V$xxx tables thus allowing the program to be run in debug to determine what cursors are not being closed. I can get the SID from V$SESSION but have not been able to figure out how to find what is open. V$OPEN_CURSOR apparently shows what is in the cache, not what is open.