Oracle. Current session longops

query.sql

SELECT s.username,
       sl.sid,
       sq.executions,
       sl.last_update_time,
       sl.sql_id,
       sl.sql_hash_value,
       opname,
       target,
       elapsed_seconds,
       time_remaining,
       sq.sql_fulltext
  FROM 
  v$session_longops sl, v$sql sq, v$session s
  where
    sq.sql_id = sl.sql_id and
    sl.SID = s.SID and
    sl.serial# = s.serial# and
    time_remaining > 0
 ;