Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_SEQUENCES

Description of the user's own SEQUENCEs

Columns
   ___________________________
 
   SEQUENCE_NAME
      SEQUENCE name
   MIN_VALUE
      Minimum value of the sequence
   MAX_VALUE
      Maximum value of the sequence
   INCREMENT_BY
      Value by which sequence is incremented
   CYCLE_FLAG
      Does sequence wrap around on reaching limit?
   ORDER_FLAG
      Are sequence numbers generated in order?
   CACHE_SIZE
      Number of sequence numbers to cache
   LAST_NUMBER
      Last sequence number written to disk

Related:



Simon Sheppard
SS64.com