Session window

[Bert Gombos]

Hi all,

A useful Session Query:

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

 

[rbrooker]

Hi,

I tried this, but on some sessions, i get disconnected from the database... weird...