v$session_longops
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: v$session_longops

  1. #1
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360

    v$session_longops

    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

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    I suspect the former. Trace it - it should become apparent.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width