JDBC Driver & Open Cursors

  • Document ID:3011960
  • Creation Date:06-Dec-2006
  • Modified Date:29-Apr-2013
    • Micro Focus Products:
      Identity Manager

Environment

Novell Identity Manager Driver- JDBC Driver

Situation

Is there an SQL statement for identifying open cursors, who opened them, and what the SQL was that caused the cursor to be opened?

Resolution

SELECT * FROM v$open_cursor WHERE USER_NAME = 'IDM'. Make sure to adapt the USER_NAME value if it's something other than 'IDM'.