with 

 long_operations as 

       (Select  l.SID,l.START_TIME,l.TIME_REMAINING,l.MESSAGE,l.LAST_UPDATE_TIME

From v$session_longops l         

Order By l.LAST_UPDATE_TIME Desc)

Select  swh.SEQ#,
            sess.SID,
            sess.USERNAME,
            swh.EVENT,
            swh.p1,
            swh.P1text,
            swh.P2,
            swh.P2text,
            swh.p3,
            swh.P3text,
            swh.state,
            s.SQL_FULLTEXT,
            swh.wait_time_micro,swh.time_remaining_micro,
            (Select h.TIME_REMAINING  From long_operations h 
             Where h.SID= swh.SID And Rownum<2) possible_remain_time
From v$session sess, v$session_wait swh,v$sql s
Where sess.SID=swh.SID And s.sql_id(+)=sess.SQL_ID;