How to get the sql-statements of all truly open cursors (not marked as "closable")?
I need to select and watch the SELECT/INSERT/UPDATE-Statements of all open cursors hold by the session at several times during applications runtime. I know v$open_cursor shows cached cursors. But not all cursors are cached and not every cached cursor is truly open. How to get the sql-statements of all truly open cursors (not marked as "closable")?
0