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