DBA_SEQUENCES

Description of all SEQUENCEs in the database

Columns
   ___________________________
 
   CYCLE_FLAG
      Does sequence wrap around on reaching limit?
   SEQUENCE_OWNER
      Name of the owner of the sequence
   ORDER_FLAG
      Are sequence numbers generated in order?
   LAST_NUMBER
      Last sequence number written to disk
   MAX_VALUE
      Maximum value of the sequence
   MIN_VALUE
      Minimum value of the sequence
   SEQUENCE_NAME
      SEQUENCE name
   CACHE_SIZE
      Number of sequence numbers to cache
   INCREMENT_BY
      Value by which sequence is incremented

Related Commands:

Simon Sheppard
SS64.com