第1个回答 2009-02-18
能查出长时间操作的语句,用你的拥有dba权限的用户执行下边的sql就行
select/*+rule*/ 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;