GV$AW_CALC

select
inst_id,                 -- INST_ID NUMBER
session_id,              -- SESSION_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
cdmlcmd,                 -- CURR_DML_COMMAND VARCHAR2(64)
pdmlcmd,                 -- PREV_DML_COMMAND VARCHAR2(64)
aggr_func_logical_na,    -- AGGR_FUNC_LOGICAL_NA NUMBER
aggr_func_precompute,    -- AGGR_FUNC_PRECOMPUTE NUMBER
aggr_func_calcs          -- AGGR_FUNC_CALCS NUMBER
from
x$xsaggr
home |  up  |  mailbox