查 sql or 會話的進度

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;