GV$SESSION_LONGOPS definition in Oracle 10g / www.oracledba.ru
GV$SESSION_LONGOPS
select
inst_id, -- INST_ID NUMBER
ksulosno, -- SID NUMBER
ksulosrn, -- SERIAL# NUMBER
ksulopna, -- OPNAME VARCHAR2(64)
ksulotna, -- TARGET VARCHAR2(64)
ksulotde, -- TARGET_DESC VARCHAR2(32)
ksulosfr, -- SOFAR NUMBER
ksulotot, -- TOTALWORK NUMBER
ksulouni, -- UNITS VARCHAR2(32)
to_date -- START_TIME DATE
(ksulostm, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
to_date -- LAST_UPDATE_TIME DATE
(ksulolut, 'MM/DD/RR HH24:MI:SS', 'NLS_CALENDAR=Gregorian'),
decode -- TIME_REMAINING NUMBER
(sign (ksulotot-ksulosfr), -1, to_number (NULL), decode (ksulosfr, 0, to_number (NULL), round (ksuloetm* ((ksulotot-ksulosfr) /ksulosfr)))),
ksuloetm, -- ELAPSED_SECONDS NUMBER
ksuloctx, -- CONTEXT NUMBER
ksulomsg, -- MESSAGE VARCHAR2(512)
ksulounm, -- USERNAME VARCHAR2(30)
ksulosql, -- SQL_ADDRESS RAW(4)
ksulosqh, -- SQL_HASH_VALUE NUMBER
ksulosqi, -- SQL_ID VARCHAR2(13)
ksuloqid -- QCSID NUMBER
from
x$ksulop