Oracle Data Dictionary

V$SESSION_LONGOPS

Columns
   ___________________________
 
   SID
   SERIAL#
   UPDATE_COUNT
   COMPNAM
   OBJID  
   CONTEXT
   STEPID
   MSG         
   STEPSSOFAR 
   STEPTOTAL
   SOFAR
   TOTALWORK
   APPLICATION_DATA_1
   APPLICATION_DATA_2
   APPLICATION_DATA_3
   START_TIME
   CURRENT_TIME
   ELAPSED_SECONDS

Columns below are in Oracle 7 only
   MESSAGE
   USERNAME
   SQL_ADDRESS
   SQL_HASH_VALUE
   QCSID
   TIME_REMAINING
   LAST_UPDATE_TIME
   UNITS
   TARGET_DESC
   TARGET
   OPNAME

Related Views:

V$ACCESS
V$MYSTAT 
V$PROCESS 				
V$SESSION 
V$SESSION_CONNECT_INFO 
V$SESSION_CURSOR_CACHE 
V$SESSION_EVENT 
V$SESSION_OBJECT_CACHE 
V$SESSION_WAIT 
V$SESSTAT 
V$SESS_IO 




Back to the Top

Simon Sheppard
SS64.com