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

home |  up  |  mailbox