--捕捉运行很久的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博客 ” ，链接：https://blog.itpub.net/15247/viewspace-965543/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
关于oracle的行级锁
请登录后发表评论
登录
全部评论
