GV$SQL_WORKAREA_ACTIVE definition in Oracle Database 11.2
GV$SQL_WORKAREA_ACTIVE
select
INST_ID, -- INST_ID NUMBER
SQLHASHV, -- SQL_HASH_VALUE NUMBER
SQLID, -- SQL_ID VARCHAR2(13)
EXECSTA, -- SQL_EXEC_START DATE
decode( -- SQL_EXEC_ID NUMBER
execid, 0, to_number(NULL), execid),
WADDR, -- WORKAREA_ADDRESS RAW(8)
substr(OPER_TYPE, 1, 20), -- OPERATION_TYPE VARCHAR2(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