select
  NAMESPACE,                               -- NAMESPACE VARCHAR2(64)
  GETS,                                    -- GETS NUMBER
  GETHITS,                                 -- GETHITS NUMBER
  GETHITRATIO,                             -- GETHITRATIO NUMBER
  PINS,                                    -- PINS NUMBER
  PINHITS,                                 -- PINHITS NUMBER
  PINHITRATIO,                             -- PINHITRATIO NUMBER
  RELOADS,                                 -- RELOADS NUMBER
  INVALIDATIONS,                           -- INVALIDATIONS NUMBER
  DLM_LOCK_REQUESTS,                       -- DLM_LOCK_REQUESTS NUMBER
  DLM_PIN_REQUESTS,                        -- DLM_PIN_REQUESTS NUMBER
  DLM_PIN_RELEASES,                        -- DLM_PIN_RELEASES NUMBER
  DLM_INVALIDATION_REQUESTS,               -- DLM_INVALIDATION_REQUESTS NUMBER
  DLM_INVALIDATIONS                        -- DLM_INVALIDATIONS NUMBER
from
  GV$LIBRARYCACHE
where
  inst_id = USERENV('Instance')