-------------See the session have in long ops-------
select sid,SOFAR,TOTALWORK,to_char(START_TIME,'dd-mm-yy hh24:mi:ss') "Start",
to_char(LAST_UPDATE_TIME,'dd-mm-yy hh24:mi:ss') "LastUpdate",TIME_REMAINING
from v$session_longops where sid='&SID';