DBA_SEQUENCES v10

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

NameTypeDescription
sequence_ownerTEXTUser name of the sequence's owner.
schema_nameTEXTThe name of the schema in which the sequence resides.
sequence_nameTEXTName of the sequence.
min_valueNUMERICThe lowest value that the server will assign to the sequence.
max_valueNUMERICThe highest value that the server will assign to the sequence.
increment_byNUMERICThe value added to the current sequence number to create the next sequent number.
cycle_flagCHARACTER VARYINGSpecifies if the sequence should wrap when it reaches min_value or max_value.
order_flagCHARACTER VARYINGWill always return Y.
cache_sizeNUMERICThe number of pre-allocated sequence numbers stored in memory.
last_numberNUMERICThe value of the last sequence number saved to disk.