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;
Oracle中捕捉运行很久的sql
最新推荐文章于 2023-07-21 17:07:43 发布