SELECT
  INST_ID,                                 -- INST_ID NUMBER
  PHADD_QKSMM,                             -- ADDRESS RAW(8)
  HASHV_QKSMM,                             -- HASH_VALUE NUMBER
  SQLID_QKSMM,                             -- SQL_ID VARCHAR2(13)
  CHILDNO_QKSMM,                           -- CHILD_NUMBER NUMBER
  WADDR_QKSMM,                             -- WORKAREA_ADDRESS RAW(8)
  substr(OPERTYPE_QKSMM, 1, 20),           -- OPERATION_TYPE VARCHAR2(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 + SPAACTS_QKSMM + MPAACTS_QKSMM),-- TOTAL_EXECUTIONS NUMBER
  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