this is the output from v$session_longops for a particular SID that's running a long batch job:
Code:
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
------------------------------ ---------------- -------------- ----------
18 24501 Sort Output
37797 22831
Blocks 21-JUL-2004 17:04:59 22-JUL-2004 11:55:55 67856 0
Sort Output: : 37797 out of 22831 Blocks done
SETT_BATCH 00000003A32D2368 2988677718 0
My question is about the timings shown - is this the amount of time that the session has spent sorting (which would be worrying) or the amount of time the session has been active for. The session is looping round a number of different SQL statements.
Cheers,
Fraze