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
home |  up  |  mailbox