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

Parameter Type Description
sequence_owner TEXT The username of the owner to which the sequence belongs.
schema_name TEXT The name of the schema to which the sequence belongs.
sequence_name TEXT The name of the sequence.
min_value NUMERIC The minimum value that the server assigns to the sequence.
max_value NUMERIC The maximum value that the server assigns to the sequence.
increment_by NUMERIC The value added to the current sequence number to create the next sequence number.
cycle_flag CHARACTER VARYING Indicates whether the sequence wraps if it reaches min_value or max_value.
order_flag CHARACTER VARYING This parameter always returns the value of Y.
cache_size NUMERIC The number of preallocated sequence numbers stored in memory.
last_number NUMERIC The value of the last sequence number saved to the disk.