Database Administration (MOSC)

MOSC Banner

question: how can SQL_PLAN_LINE_ID be derived from v$session_longops in 10.2.0.4

edited Sep 8, 2009 3:15AM in Database Administration (MOSC) 2 commentsAnswered
Does anyone have a query for 10.2.0.4 to link a row of
v$session_longops to the line number of an execution plan ?

v$session_longops in 11g has the handy column
SQL_PLAN_LINE_ID.  SQL_PLAN_LINE_ID is exactly what I wish I had in
10gr2.

No luck so far searching Google and metalink.

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