V$SESSION_LONGOPS definition in Oracle Database 11.2
V$SESSION_LONGOPS

select
  SID,                                     -- SID NUMBER
  SERIAL#,                                 -- SERIAL# NUMBER
  OPNAME,                                  -- OPNAME VARCHAR2(64)
  TARGET,                                  -- TARGET VARCHAR2(64)
  TARGET_DESC,                             -- TARGET_DESC VARCHAR2(32)
  SOFAR,                                   -- SOFAR NUMBER
  TOTALWORK,                               -- TOTALWORK NUMBER
  UNITS,                                   -- UNITS VARCHAR2(32)
  START_TIME,                              -- START_TIME DATE
  LAST_UPDATE_TIME,                        -- LAST_UPDATE_TIME DATE
  TIMESTAMP,                               -- TIMESTAMP DATE
  TIME_REMAINING,                          -- TIME_REMAINING NUMBER
  ELAPSED_SECONDS,                         -- ELAPSED_SECONDS NUMBER
  CONTEXT,                                 -- CONTEXT NUMBER
  MESSAGE,                                 -- MESSAGE VARCHAR2(512)
  USERNAME,                                -- USERNAME VARCHAR2(30)
  SQL_ADDRESS,                             -- SQL_ADDRESS RAW(8)
  SQL_HASH_VALUE,                          -- SQL_HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SQL_PLAN_HASH_VALUE,                     -- SQL_PLAN_HASH_VALUE NUMBER
  SQL_EXEC_START,                          -- SQL_EXEC_START DATE
  SQL_EXEC_ID,                             -- SQL_EXEC_ID NUMBER
  SQL_PLAN_LINE_ID,                        -- SQL_PLAN_LINE_ID NUMBER
  SQL_PLAN_OPERATION,                      -- SQL_PLAN_OPERATION VARCHAR2(30)
  SQL_PLAN_OPTIONS,                        -- SQL_PLAN_OPTIONS VARCHAR2(30)
  QCSID                                    -- QCSID NUMBER
from
  GV$SESSION_LONGOPS
where
  inst_id = USERENV('Instance')

home |  up