Database Administration (MOSC)

MOSC Banner

How to get the sql-statements of all truly open cursors (not marked as "closable")?

edited Apr 23, 2009 3:29PM in Database Administration (MOSC) 2 commentsAnswered
 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")?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center