uilian

--
-- Mostra o andamento de operacoes longas no Oracle.
--
select target, sofar, totalwork, ROUND((sofar/totalwork)*100,5) pct_done 
  from v$session_longops 
 where (sid, serial#) in (select sid, serial# 
                            from v$session 
                           where logon_time > trunc(sysdate))
order by pct_done;