GV$PGA_TARGET_ADVICE

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