select
  INST_ID,                                 -- INST_ID NUMBER
  PAT_PRED * 1024,                         -- PGA_TARGET_FOR_ESTIMATE NUMBER
  round(PAT_PRED/PAT_CURR, 4),             -- PGA_TARGET_FACTOR NUMBER
  decode(status, 0, 'OFF', 'ON'),          -- ADVICE_STATUS VARCHAR2(3)
  BYTES_PROCESSED * 1024,                  -- BYTES_PROCESSED NUMBER
  ESTD_TIME,                               -- ESTD_TIME NUMBER
  EXTRA_BYTES_RW * 1024,                   -- ESTD_EXTRA_BYTES_RW NUMBER
  round(decode(BYTES_PROCESSED+EXTRA_BYTES_RW, 0, 0, (BYTES_PROCESSED*100)/(BYTES_PROCESSED+EXTRA_BYTES_RW))),-- ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
  OVERALLOC                                -- ESTD_OVERALLOC_COUNT NUMBER
from
  X$QESMMAPADV