--捕捉运行很久的SQL
select username,sid,opname,
round(sofar*100 / totalwork,0) || '%' as progress,
time_remaining,sql_text ,elapsed_seconds,start_time,message
from v$session_longops , v$sql
where
sql_address = address
and sql_hash_value = hash_value
[@more@]
select username,sid,opname,
round(sofar*100 / totalwork,0) || '%' as progress,
time_remaining,sql_text ,elapsed_seconds,start_time,message
from v$session_longops , v$sql
where
sql_address = address
and sql_hash_value = hash_value
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15247/viewspace-965543/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15247/viewspace-965543/