GV$SQL_WORKAREA_ACTIVE definition in Oracle Database 10.2 / www.oracledba.ru
GV$SQL_WORKAREA_ACTIVE
select
INST_ID, -- INST_ID NUMBER
SQLHASHV, -- SQL_HASH_VALUE NUMBER
SQLID, -- SQL_ID VARCHAR2(13)
WADDR, -- WORKAREA_ADDRESS RAW(4)
substr -- OPERATION_TYPE VARCHAR2(20)
(OPER_TYPE, 1, 20),
to_number -- OPERATION_ID NUMBER
(decode (OPID, 65535, NULL, OPID)),
substr -- POLICY VARCHAR2(6)
(decode (bitand (MEM_FLAGS, 1), 0, 'MANUAL', 'AUTO'), 1, 6),
SID, -- SID NUMBER
to_number -- QCINST_ID NUMBER
(decode (QCINSTID, 65535, NULL, QCINSTID)),
to_number -- QCSID NUMBER
(decode (QCSID, 65535, NULL, QCSID)),
ATIME, -- ACTIVE_TIME NUMBER
WA_SIZE * 1024, -- WORK_AREA_SIZE NUMBER
to_number -- EXPECTED_SIZE NUMBER
(decode (bitand (MEM_FLAGS, 1), 0, NULL, EXP_SIZE*1024)),
ACTUAL_MEM * 1024, -- ACTUAL_MEM_USED NUMBER
MAX_MEM * 1024, -- MAX_MEM_USED NUMBER
PASSES, -- NUMBER_PASSES NUMBER
to_number -- TEMPSEG_SIZE NUMBER
(decode (KTSSOTSN, '', NULL, KTSSOSIZE*1024)),
decode -- TABLESPACE VARCHAR2(30)
(KTSSOTSN, '', NULL, KTSSOTSN),
to_number -- SEGRFNO# NUMBER
(decode (KTSSOTSN, '', NULL, KTSSORFNO)),
to_number -- SEGBLK# NUMBER
(decode (KTSSOTSN, '', NULL, KTSSOBNO))
from
x$qesmmiwt