select
  OWNER,                                   -- OWNER VARCHAR2(64)
  NAME,                                    -- NAME VARCHAR2(1000)
  DB_LINK,                                 -- DB_LINK VARCHAR2(64)
  NAMESPACE,                               -- NAMESPACE VARCHAR2(64)
  TYPE,                                    -- TYPE VARCHAR2(64)
  SHARABLE_MEM,                            -- SHARABLE_MEM NUMBER
  LOADS,                                   -- LOADS NUMBER
  EXECUTIONS,                              -- EXECUTIONS NUMBER
  LOCKS,                                   -- LOCKS NUMBER
  PINS,                                    -- PINS NUMBER
  KEPT,                                    -- KEPT VARCHAR2(3)
  CHILD_LATCH,                             -- CHILD_LATCH NUMBER
  INVALIDATIONS,                           -- INVALIDATIONS NUMBER
  HASH_VALUE,                              -- HASH_VALUE NUMBER
  LOCK_MODE,                               -- LOCK_MODE VARCHAR2(9)
  PIN_MODE,                                -- PIN_MODE VARCHAR2(9)
  STATUS,                                  -- STATUS VARCHAR2(19)
  TIMESTAMP,                               -- TIMESTAMP VARCHAR2(19)
  PREVIOUS_TIMESTAMP,                      -- PREVIOUS_TIMESTAMP VARCHAR2(19)
  LOCKED_TOTAL,                            -- LOCKED_TOTAL NUMBER
  PINNED_TOTAL                             -- PINNED_TOTAL NUMBER
from
  GV$DB_OBJECT_CACHE
where
  inst_id = USERENV('Instance')