REM
REM DBAToolZ NOTE:
REM	This script was obtained from DBAToolZ.com
REM	It's configured to work with SQL Directory (SQLDIR).
REM	SQLDIR is a utility that allows easy organization and
REM	execution of SQL*Plus scripts using user-friendly menu.
REM	Visit DBAToolZ.com for more details and free SQL scripts.
REM
REM 
REM File:
REM 	s_user_long_ops.sql
REM
REM <SQLDIR_GRP>USER MOST TRACE</SQLDIR_GRP>
REM 
REM Author:
REM 	Vitaliy Mogilevskiy 
REM	VMOGILEV
REM	(vit100gain@earthlink.net)
REM 
REM Purpose:
REM	<SQLDIR_TXT>
REM	Reports long running processes
REM	</SQLDIR_TXT>
REM	
REM Usage:
REM	s_user_long_ops.sql
REM 
REM Example:
REM	s_user_long_ops.sql
REM
REM
REM History:
REM	08-01-1998	VMOGILEV	Created
REM
REM

set lines 132
set trims on
col username format a10 truncate

select sid, serial#, username, context,
  round(sofar/DECODE(totalwork,0,1)*100,2) "% Complete",
  elapsed_seconds/60 "Elapsed Min",
  time_remaining/60 "Min to complete",
  substr(to_char(sysdate,'yymmdd hh24:mi:ss'),1,15) "Time Now"
from v$session_longops log
where round(sofar/DECODE(totalwork,0,1)*100,2) < 100
order by time_remaining desc, username
/