longops.sql

 

rem LONGOPS.SQL

rem Long Running Statements

rem Helmut Pfau, Oracle Deutschland GmbH

set linesize 120

col opname format a20

col target format a15

col units format a10

col time_remaining format 99990 heading Remaining[s]

col bps format 9990.99 heading [Units/s]

col fertig format 90.99 heading "complete[%]"

select sid,

       opname,

       target,

       sofar,

       totalwork,

       units,

       (totalwork-sofar)/time_remaining bps,

       time_remaining,

       sofar/totalwork*100 fertig

from   v$session_longops

where  time_remaining > 0

/