select
  inst_id,                                 -- INST_ID NUMBER
  kglnaown,                                -- OWNER VARCHAR2(64)
  kglnaobj,                                -- NAME VARCHAR2(1000)
  kglnadlk,                                -- DB_LINK VARCHAR2(64)
  kglhdnsd,                                -- NAMESPACE VARCHAR2(64)
  kglobtyd,                                -- TYPE VARCHAR2(64)
  kglobhs0+kglobhs1+kglobhs2+kglobhs3+kglobhs4+kglobhs5+kglobhs6,-- SHARABLE_MEM NUMBER
  kglhdldc,                                -- LOADS NUMBER
  kglhdexc,                                -- EXECUTIONS NUMBER
  kglhdlkc,                                -- LOCKS NUMBER
  kglobpc0,                                -- PINS NUMBER
  decode(kglhdkmk,0,'NO','YES'),           -- KEPT VARCHAR2(3)
  kglhdclt,                                -- CHILD_LATCH NUMBER
  kglhdivc,                                -- INVALIDATIONS NUMBER
  kglnahsh,                                -- HASH_VALUE NUMBER
  decode(                                  -- LOCK_MODE VARCHAR2(9)
    kglhdlmd, 0, 'NONE', 1, 'NULL', 2, 'SHARED', 3, 'EXCLUSIVE', 'UNKOWN'),
  decode(                                  -- PIN_MODE VARCHAR2(9)
    kglhdpmd, 0, 'NONE', 1, 'NULL', 2, 'SHARED', 3, 'EXCLUSIVE', 'UNKOWN'),
  decode(                                  -- STATUS VARCHAR2(19)
    kglobsta, 1, 'VALID', 2, 'VALID_AUTH_ERROR', 3, 'VALID_COMPILE_ERROR', 4, 'VALID_UNAUTH', 5, 'INVALID_UNAUTH', 6, 'INVALID', 'UNKOWN'),
  substr(                                  -- TIMESTAMP VARCHAR2(19)
    to_char(kglnatim,'YYYY-MM-DD/HH24:MI:SS'),1,19),
  substr(                                  -- PREVIOUS_TIMESTAMP VARCHAR2(19)
    to_char(kglnaptm,'YYYY-MM-DD/HH24:MI:SS'),1,19),
  kglobt23,                                -- LOCKED_TOTAL NUMBER
  kglobt24                                 -- PINNED_TOTAL NUMBER
from
  x$kglob