select
  inst_id,                                 -- INST_ID NUMBER
  KGLNAOWN,                                -- SEQUENCE_OWNER VARCHAR2(64)
  KGLNAOBJ,                                -- SEQUENCE_NAME VARCHAR2(1000)
  KGLOBT08,                                -- OBJECT# NUMBER
  decode(                                  -- ACTIVE_FLAG VARCHAR2(1)
    bitand(KGLOBT00,1),0,'N','Y'),
  decode(                                  -- REPLENISH_FLAG VARCHAR2(1)
    bitand(KGLOBT00,2),0,'N','Y'),
  decode(                                  -- WRAP_FLAG VARCHAR2(1)
    bitand(KGLOBT00,16),0,'N','Y'),
  KGLOBTN0,                                -- NEXTVALUE NUMBER
  KGLOBTN2,                                -- MIN_VALUE NUMBER
  KGLOBTN3,                                -- MAX_VALUE NUMBER
  KGLOBTN1,                                -- INCREMENT_BY NUMBER
  decode(                                  -- CYCLE_FLAG VARCHAR2(1)
    bitand(KGLOBT09,1),0,'N','Y'),
  decode(                                  -- ORDER_FLAG VARCHAR2(1)
    bitand(KGLOBT09,2),0,'N','Y'),
  KGLOBTN4,                                -- CACHE_SIZE NUMBER
  KGLOBTN5,                                -- HIGHWATER NUMBER
  decode(KGLOBT10,1,'Y','N'),              -- BACKGROUND_INSTANCE_LOCK VARCHAR2(1)
  decode(                                  -- INSTANCE_LOCK_FLAGS NUMBER
    KGLOBT10,1,KGLOBT02,null) 
from
  X$KGLOB
where
  KGLOBTYP = 6 and KGLOBT11 = 1