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   Received on Thu Mar 29 2001 - 19:37:04 CST