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')