SELECT s.sid,
s.serial#,
sl.TARGET_DESC,
sl.TARGET,
s.machine,
(select sql_text from v$sql a where a.HASH_VALUE=s.SQL_HASH_VALUE and rownum=1) sql,
TRUNC(sl.elapsed_seconds / 60) || ':' || MOD(sl.elapsed_seconds, 60) elapsed,
TRUNC(sl.time_remaining / 60) || ':' || MOD(sl.time_remaining, 60) remaining,
ROUND(sl.sofar / sl.totalwork * 100, 2) progress_pct
FROM v$session s, v$session_longops sl
WHERE s.sid = sl.sid
AND s.serial# = sl.serial#
--and s.sid='325'
and s.STATUS='ACTIVE'
and s.USERNAME is not null