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

ITPub博客

oracle 长sql监控