DBA_SEQUENCES

Description of all SEQUENCEs in the database

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

Related:

Simon Sheppard
SS64.com