DBA_SEQUENCES v16

The DBA_SEQUENCES view provides information about all user-defined sequences.

NameTypeDescription
sequence_ownerTEXTUser name of the sequence's owner.
schema_nameTEXTName of the schema in which the sequence resides.
sequence_nameTEXTName of the sequence.
min_valueNUMERICLowest value that the server assigns to the sequence.
max_valueNUMERICHighest value that the server assigns to the sequence.
increment_byNUMERICValue added to the current sequence number to create the next sequent number.
cycle_flagCHARACTER VARYINGSpecifies whether the sequence wraps when it reaches min_value or max_value.
order_flagCHARACTER VARYINGAlways returns Y.
cache_sizeNUMERICThe number of preallocated sequence numbers stored in memory.
last_numberNUMERICThe value of the last sequence number saved to disk.