Script to identify Long Running Statements in Database

By | September 15th, 2012|DBA Miscellaneous, Oracle DBA|

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,         [...]