检查sql or session 执行的进度

1. check the progress of sql running.

select SID,SERIAL#,OPNAME,SOFAR,TOTALWORK,SOFAR/TOTALWORK per from v$session_longops where sid in

select sid from v$session where command like '9') order by per desc;

2. 查sql的进度.

select sid, serial#, opname, to_char(start_time, 'HH24:MI:SS') AS "START", (sofar/totalwork)*100 as percent_complete from v$session_longops;

3. 查会话的进度：

select sid,username,serial#,context,sofar,totalwork,opname,round(sofar/totalwork*100,2) "%Complete"
from v$session_longops where opname not like '%aggregate%' and totalwork!=0 and sofar<>totalwork;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22578826/viewspace-709889/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22578826/viewspace-709889/