Explain Plan for SQL Text in Sessions Window

[tphalen]

A possible enhancement:
From the Tools menu select Sessions...
In the Sessions window select the a session and then use the tabs to change to SQL Text.
Right mouse button click on a select statement.

Enhancement: Add explain plan to this select statement.

Thanks
Tom

 

[Bert Gombos]

Create a new session query on Session window. Try this:

select t.id,
lpad(' ', 2*t.depth) || t.operation || ' ' || t.options Description,
t.object_owner,
t.object_name,
t.cost,
t.cardinality,
t.bytes,
t.access_predicates,
t.filter_predicates
from v$sql_plan t
where t.address = hextorawsql_address)
order by t.id

 

[tphalen]

Bert:

Thanks for the reply, but I found a small problem. The variable :sql_address is not bound. Is there a place to bind the variables used by the session sqls?

Thanks,
Tom

 

[orca777]

hi,
would be a cool functionality
Karl

 

[orca777]

i added this to my session Detail Query!
Great! By the way the V$SQL_PLAN shows the executed plan of the SQL.

Greetings
Karl