V$SESSION_LONGOPS

Use this feature to indicate the progress of long running PL/SQL operations (set with dbms_application_info.)

Columns
   ___________________________
 
   SID
   SERIAL#
   OPNAME
   TARGET
   TARGET_DESC
   SOFAR
   TOTALWORK
   UNITS
   START_TIME
   LAST_UPDATE_TIME
   TIME_REMAINING
   ELAPSED_SECONDS
   CONTEXT
   MESSAGE
   USERNAME
   SQL_ADDRESS
   SQL_HASH_VALUE
   QCSID

Related:

DBMS_APPLICATION_INFO.set_session_longops
DBMS_APPLICATION_INFO.set_module
V$ACCESS
V$MYSTAT 
V$PROCESS 				
V$SESSION.sid
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_OBJECT_CACHE 
V$SESSION_WAIT 
V$SESSTAT 
V$SESS_IO 


© Copyright SS64.com 1999-2013
Some rights reserved