Get details about long running operations : v$session_longops

Getting the detail of long running queries:
Alter session set nls_date_format = 'DD-Mon-YYYY HH24:MI:SS' ; 

set line 1000 
column OPNAME format a20
column target format a50

    
SELECT S.SID, sl.sql_id,opname,target, sl.last_update_time ,

elapsed_seconds/60 elepsed_min ,

time_remaining/60 time_rem_min ,  

((elapsed_seconds/(elapsed_seconds+time_remaining)) * 100 ) percent_complete 

FROM v$session_longops sl inner join v$session s 
ON sl.SID = s.SID AND sl.SERIAL# = s.SERIAL#

 WHERE time_remaining > 0 ;


Getting the SQLs of the above long running queries:
----------------------------------------------------
SELECT s.username,
       sl.sid,
       sq.executions,
       sq.sql_fulltext
  FROM v$session_longops sl
 INNER JOIN v$sql sq ON sq.sql_id = sl.sql_id
 INNER JOIN v$session s ON sl.SID = s.SID AND sl.serial# = s.serial#
 WHERE time_remaining > 0  ;