Oracle 11.0.1.7:
If I have a query already running and want to see which part of query is taking long time then is there a way to look in v$ views the breakdown of each subquery?
for eg:
select * from fil f
where x in (select * from typ t, typ1 t1 where t.tid = t1.tid and t1.tid = f.tid)
and x in (select * from form f where f.fid = t.fid and);