SQL語句執行進度檢查

--SQL語句執行進度檢查（只對經過表分析的表有效）
select st.piece, st.sql_text, (case when st.piece = 0 then round(sl.sofar/sl.totalwork, 4) * 100 else null end) "Progress(%)"
from v$session_longops sl, v$sqltext st
where st.hash_value = sl.sql_hash_value
and st.address = hextoraw(sl.sql_address)
and sl.sofar <> sl.totalwork
order by st.piece

修改了下，如果對於多個同時進行的SQL語句，需要進行分組
select st.piece, st.hash_value, st.sql_text, (case when st.piece = 0 then round(sl.sofar/sl.totalwork, 4) * 100 else null end) "Progress(%)"
from v$session_longops sl, v$sqltext st
where st.hash_value = sl.sql_hash_value
and st.address = hextoraw(sl.sql_address)
and sl.sofar <> sl.totalwork
order by st.hash_value, st.piece