DBA_SEQUENCES view tips

Oracle Tips by Burleson Consulting

DBA_SEQUENCES

<< Return to the index

Oracle 11g makes the following comments about the DBA_SEQUENCES table: "Description of all SEQUENCEs in the database"

Related notes on DBA_SEQUENCES:

Column description of the DBA_SEQUENCES view:

SEQUENCE_OWNER

Description of DBA_SEQUENCES.SEQUENCE_OWNER: "Name of the owner of the sequence"

SEQUENCE_NAME

Description of DBA_SEQUENCES.SEQUENCE_NAME: "SEQUENCE name"

MIN_VALUE

Description of DBA_SEQUENCES.MIN_VALUE: "Minimum value of the sequence"

MAX_VALUE

Description of DBA_SEQUENCES.MAX_VALUE: "Maximum value of the sequence"

INCREMENT_BY

Description of DBA_SEQUENCES.INCREMENT_BY: "Value by which sequence is incremented"

CYCLE_FLAG

Description of DBA_SEQUENCES.CYCLE_FLAG: "Does sequence wrap around on reaching limit?"

ORDER_FLAG

Description of DBA_SEQUENCES.ORDER_FLAG: "Are sequence numbers generated in order?"

CACHE_SIZE

Description of DBA_SEQUENCES.CACHE_SIZE: "Number of sequence numbers to cache"

LAST_NUMBER

Description of DBA_SEQUENCES.LAST_NUMBER: "Last sequence number written to disk"

DBA_SEQUENCES View Source

Oracle 11g's data dictionary defines the DBA_SEQUENCES view using the following source query:

select u.name, o.name,
s.minvalue, s.maxvalue, s.increment$,
decode (s.cycle#, 0, 'N', 1, 'Y'),
decode (s.order$, 0, 'N', 1, 'Y'),
s.cache, s.highwater
from sys.seq$ s, sys.obj$ o, sys.user$ u
where u.user# = o.owner#
and o.obj# = s.obj#

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books