select
  SESSION_ID,                              -- SESSION_ID NUMBER
  AGGREGATE_CACHE_HITS,                    -- AGGREGATE_CACHE_HITS NUMBER
  AGGREGATE_CACHE_MISSES,                  -- AGGREGATE_CACHE_MISSES NUMBER
  SESSION_CACHE_HITS,                      -- SESSION_CACHE_HITS NUMBER
  SESSION_CACHE_MISSES,                    -- SESSION_CACHE_MISSES NUMBER
  POOL_HITS,                               -- POOL_HITS NUMBER
  POOL_MISSES,                             -- POOL_MISSES NUMBER
  POOL_NEW_PAGES,                          -- POOL_NEW_PAGES NUMBER
  POOL_RECLAIMED_PAGES,                    -- POOL_RECLAIMED_PAGES NUMBER
  CACHE_WRITES,                            -- CACHE_WRITES NUMBER
  POOL_SIZE,                               -- POOL_SIZE NUMBER
  CURR_DML_COMMAND,                        -- CURR_DML_COMMAND VARCHAR2(64)
  PREV_DML_COMMAND,                        -- 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
  gv$aw_calc
where
  inst_id = USERENV('Instance')