GV$AW_CALC

select
inst_id,                 -- INST_ID NUMBER
agcachhit,               -- AGGREGATE_CACHE_HITS NUMBER
agcachmiss,              -- AGGREGATE_CACHE_MISSES NUMBER
scachesuccess,           -- SESSION_CACHE_HITS NUMBER
scachefailure,           -- SESSION_CACHE_MISSES NUMBER
pgcachhit,               -- POOL_HITS NUMBER
pgcachmiss,              -- POOL_MISSES NUMBER
pgnewpage,               -- POOL_NEW_PAGES NUMBER
pgscrounge,              -- POOL_RECLAIMED_PAGES NUMBER
pgcachewrite,            -- CACHE_WRITES NUMBER
pgpoolsize               -- POOL_SIZE NUMBER
from
x$xsaggr
home |  up  |  mailbox