select
  pins,                                    -- PINS NUMBER
  hits,                                    -- HITS NUMBER
  true_hits,                               -- TRUE_HITS NUMBER
  hit_ratio,                               -- HIT_RATIO NUMBER
  true_hit_ratio,                          -- TRUE_HIT_RATIO NUMBER
  object_refreshes,                        -- OBJECT_REFRESHES NUMBER
  cache_refreshes,                         -- CACHE_REFRESHES NUMBER
  object_flushes,                          -- OBJECT_FLUSHES NUMBER
  cache_flushes,                           -- CACHE_FLUSHES NUMBER
  cache_shrinks,                           -- CACHE_SHRINKS NUMBER
  cached_objects,                          -- CACHED_OBJECTS NUMBER
  pinned_objects,                          -- PINNED_OBJECTS NUMBER
  cache_size,                              -- CACHE_SIZE NUMBER
  optimal_size,                            -- OPTIMAL_SIZE NUMBER
  maximum_size                             -- MAXIMUM_SIZE NUMBER
from
  gv$session_object_cache
where
  inst_id=userenv('Instance')