答案:09.05]:如何捕捉运行很久的SQL?
column username format a12
column opname format a16
column progress format a8
select username,sid,opname,
round(sofar*100 / totalwork,0) || '%' as progress,
time_remaining,sql_text
from v$session_longops , v$sql
where time_remaining <> 0
and sql_address = address
and sql_hash_value = hash_value
/本文来自:http://doc.linuxpk.com/3458.html
发表您的高见!