V$_SEQUENCES definition in Oracle Database 11.2
V$_SEQUENCES

select
  SEQUENCE_OWNER,                          -- SEQUENCE_OWNER VARCHAR2(64)
  SEQUENCE_NAME,                           -- SEQUENCE_NAME VARCHAR2(1000)
  OBJECT#,                                 -- OBJECT# NUMBER
  ACTIVE_FLAG,                             -- ACTIVE_FLAG VARCHAR2(1)
  REPLENISH_FLAG,                          -- REPLENISH_FLAG VARCHAR2(1)
  WRAP_FLAG,                               -- WRAP_FLAG VARCHAR2(1)
  NEXTVALUE,                               -- NEXTVALUE NUMBER
  MIN_VALUE,                               -- MIN_VALUE NUMBER
  MAX_VALUE,                               -- MAX_VALUE NUMBER
  INCREMENT_BY,                            -- INCREMENT_BY NUMBER
  CYCLE_FLAG,                              -- CYCLE_FLAG VARCHAR2(1)
  ORDER_FLAG,                              -- ORDER_FLAG VARCHAR2(1)
  CACHE_SIZE,                              -- CACHE_SIZE NUMBER
  HIGHWATER,                               -- HIGHWATER NUMBER
  BACKGROUND_INSTANCE_LOCK,                -- BACKGROUND_INSTANCE_LOCK VARCHAR2(1)
  INSTANCE_LOCK_FLAGS                      -- INSTANCE_LOCK_FLAGS NUMBER
from
  GV$_SEQUENCES
where
  inst_id = USERENV('Instance')

home |  up