select
  PGA_TARGET_FOR_ESTIMATE,                 -- PGA_TARGET_FOR_ESTIMATE NUMBER
  PGA_TARGET_FACTOR,                       -- PGA_TARGET_FACTOR NUMBER
  ADVICE_STATUS,                           -- ADVICE_STATUS VARCHAR2(3)
  BYTES_PROCESSED,                         -- BYTES_PROCESSED NUMBER
  ESTD_TIME,                               -- ESTD_TIME NUMBER
  ESTD_EXTRA_BYTES_RW,                     -- ESTD_EXTRA_BYTES_RW NUMBER
  ESTD_PGA_CACHE_HIT_PERCENTAGE,           -- ESTD_PGA_CACHE_HIT_PERCENTAGE NUMBER
  ESTD_OVERALLOC_COUNT                     -- ESTD_OVERALLOC_COUNT NUMBER
from
  GV$PGA_TARGET_ADVICE
where
  INST_ID = USERENV('Instance')