select
  PGA_TARGET_FOR_ESTIMATE,                 -- PGA_TARGET_FOR_ESTIMATE NUMBER
  PGA_TARGET_FACTOR,                       -- PGA_TARGET_FACTOR NUMBER
  ADVICE_STATUS,                           -- ADVICE_STATUS VARCHAR2(3)
  LOW_OPTIMAL_SIZE,                        -- LOW_OPTIMAL_SIZE NUMBER
  HIGH_OPTIMAL_SIZE,                       -- HIGH_OPTIMAL_SIZE NUMBER
  ESTD_OPTIMAL_EXECUTIONS,                 -- ESTD_OPTIMAL_EXECUTIONS NUMBER
  ESTD_ONEPASS_EXECUTIONS,                 -- ESTD_ONEPASS_EXECUTIONS NUMBER
  ESTD_MULTIPASSES_EXECUTIONS,             -- ESTD_MULTIPASSES_EXECUTIONS NUMBER
  ESTD_TOTAL_EXECUTIONS,                   -- ESTD_TOTAL_EXECUTIONS NUMBER
  IGNORED_WORKAREAS_COUNT                  -- IGNORED_WORKAREAS_COUNT NUMBER
from
  GV$PGA_TARGET_ADVICE_HISTOGRAM
where
  INST_ID = USERENV('Instance')