DBA_SEQUENCES

This lists all the user sequences. It's a synonym for USER_SEQUENCES.

Fields

The most relevant view fields are as follows:

• SEQUENCE_OWNER: The owner of the sequence

• SEQUENCE_NAME: The name of the sequence

• MIN_VALUE: The minimum value of the sequence

• MAX_VALUE: The maximum value of the sequence

• INCREMENT_BY: The value by which the sequence is incremented

• CYCLE_FLAG: This indicates whether the sequence numbering restarts after it has reached the upper limit

• ORDER_FLAG: This indicates whether the sequence is ordered (numbers generated in order) or not; this is useful in an RAC environment

• CACHE_SIZE: The number of sequence numbers to cache

• LAST_NUMBER: The last number written to disk; if caching is enabled, it is the last number placed in the sequence cache