GV$_SEQUENCES

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                   -- BACKGROUND_INSTANCE_LOCK VARCHAR2(1)
  (KGLOBT10, 1, 'Y', 'N'),
decode                   -- INSTANCE_LOCK_FLAGS NUMBER
  (KGLOBT10, 1, KGLOBT02, null) 
from
X$KGLOB 
where
KGLOBTYP = 6 and KGLOBT11 = 1
home |  up  |  mailbox