GV$SQL_WORKAREA

SELECT
INST_ID,                 -- INST_ID NUMBER
PHADD_QKSMM,             -- ADDRESS RAW(4)
HASHV_QKSMM,             -- HASH_VALUE NUMBER
SQLID_QKSMM,             -- SQL_ID VARCHAR2(13)
CHILDNO_QKSMM,           -- CHILD_NUMBER NUMBER
WADDR_QKSMM,             -- WORKAREA_ADDRESS RAW(4)
substr                   -- OPERATION_TYPE VARCHAR2(20)
  (OPERTYPE_QKSMM, 1, 20),
to_number                -- OPERATION_ID NUMBER
  (decode (OPERTID_QKSMM, 65535, NULL, OPERTID_QKSMM)),
substr                   -- POLICY VARCHAR2(10)
  (SIZEPOLICY_QKSMM, 1, 10),
OPTIMAL_QKSMM * 1024,    -- ESTIMATED_OPTIMAL_SIZE NUMBER
ONEPASS_QKSMM * 1024,    -- ESTIMATED_ONEPASS_SIZE NUMBER
LASTMEM_QKSMM * 1024,    -- LAST_MEMORY_USED NUMBER
substr                   -- LAST_EXECUTION VARCHAR2(10)
  (decode (LASTPASS_QKSMM, 0, 'OPTIMAL', to_char (LASTPASS_QKSMM) || ' PASS' || decode (LASTPASS_QKSMM, 1, '', 'ES')), 1, 10),
LASTDOP_QKSMM,           -- LAST_DEGREE NUMBER
(OPTACTS_QKSMM           -- TOTAL_EXECUTIONS NUMBER
  + SPAACTS_QKSMM + MPAACTS_QKSMM),
OPTACTS_QKSMM,           -- OPTIMAL_EXECUTIONS NUMBER
SPAACTS_QKSMM,           -- ONEPASS_EXECUTIONS NUMBER
MPAACTS_QKSMM,           -- MULTIPASSES_EXECUTIONS NUMBER
ATIME_QKSMM,             -- ACTIVE_TIME NUMBER
to_number                -- MAX_TEMPSEG_SIZE NUMBER
  (decode (MAXTSEG_QKSMM, 0, NULL, MAXTSEG_QKSMM*1024)),
to_number                -- LAST_TEMPSEG_SIZE NUMBER
  (decode (LASTTSEG_QKSMM, 0, NULL, LASTTSEG_QKSMM*1024)) 
FROM
X$QKSMMWDS
home |  up  |  mailbox