捕捉运行很久的SQL

qtjqtj79

[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
/

zhanggz

顶

孙轩

好

williamw2000

That's the one!