v$session_longops join to v$sqlarea

[Hagedorn, Linda]

Title: v$session_longops join to v$sqlarea

Hi,

I'm trying to identify some of the longops queries I'm seeing:

sofar               totalwork                                                                                                           message

7.2058E+16 7.2058E+16  29-MAR-01  0  417865044 1.8447E+19 :  : 72057594037927936 out of 72057594037927936  done                           

 
I'm joining on the sqladdress, but I can't seem to catch this eggregious SQL statement.  I know the sqlarea is rolled over quickly, but I should be able to catch one of them....

select substr(l.sid,1,3),
       substr(l.serial#,1,4),
       target_desc,
       substr(l.sofar,1,17),
       substr(l.totalwork,1,17),
       units,
       l.sql_address,
       TO_CHAR(start_time, 'MM-DD-YYYY HH24:MI:SS'),  
       substr(s.sql_text,1,1000) 
from v$session_longops l , v$sqlarea s 
where l.sql_address = s.address ;

Any information is appreciated.

Thanks, Linda