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 ...

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial