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;