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

home |  up