Home Oracle Commands Oracle Data Dictionary
v$ Performance views

USER_SEQUENCES

Description of the user's own SEQUENCEs

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

Related Commands:




Back to the Top

Simon Sheppard
SS64.com