select sid, message from v$session_longops
where sid = &sid
order by start_time; 

14 Table Scan:  (stale) obj# 671097: 92409 out of 92409 Blocks done

SQL> select name from sys.obj$ where obj# = '671097';

no rows selected

SQL> select name from sys.obj$ where dataobj# = '671097';

no rows selected

SQL> select distinct b.sql_text
from v$session a, v$sqlarea b , v$session_longops c
where a.sid = c.sid
and a.sql_hash_value = b.hash_value
and c.sid='&sid';
Enter value for sid: 14
old   5: and c.sid='&sid'
new   5: and c.sid='14'

SQL_TEXT
-----------------------------------------------------------------
SELECT M.MEMBERID, MB.MEMBERID, M.EMAILADDRESS, M.WEBSITEID, M.ADDEDDATE_ID 
FROM DB1.TMP_MEMADD M, DB1.MEMBERS MB 
WHERE M.EMAILADDRESS = MB.EMAILADDRESS AND M.WEBSITEID = MB.WEBSITEID