select
  inst_id,                                 -- INST_ID NUMBER
  kocstpin,                                -- PINS NUMBER
  kocsthit,                                -- HITS NUMBER
  kocsttht,                                -- TRUE_HITS NUMBER
  decode(                                  -- HIT_RATIO NUMBER
    kocstpin,0,1,kocsthit/kocstpin),
  decode(                                  -- TRUE_HIT_RATIO NUMBER
    kocstpin,0,1,kocsttht/kocstpin),
  kocstorf,                                -- OBJECT_REFRESHES NUMBER
  kocstrfs,                                -- CACHE_REFRESHES NUMBER
  kocstofs,                                -- OBJECT_FLUSHES NUMBER
  kocstfls,                                -- CACHE_FLUSHES NUMBER
  kocstshr,                                -- CACHE_SHRINKS NUMBER
  kocstcnt,                                -- CACHED_OBJECTS NUMBER
  kocstpnd,                                -- PINNED_OBJECTS NUMBER
  kocstsiz,                                -- CACHE_SIZE NUMBER
  kocstopt,                                -- OPTIMAL_SIZE NUMBER
  kocstmax                                 -- MAXIMUM_SIZE NUMBER
from
  x$kocst