RE: v$session_longops hash join operation oddity --addition

or, perhaps , the hash join section in a 10053 trace would suffice  

regards  

I would try - if the join is still active - to start a trace via 10104 event (hash operation trace) to see the details (best is start the trace before executing

the query, of course/maybe a after logon trigger, etc. would be of use here).  

>Hi Alvaro
>The plan looks OK -- it's what we'd expect it to be ( I can't show it
unless I edit all the table names out first, and it's 140 lines long)
>Stefan

--
http://www.freelists.org/webpage/oracle-l