DATABASE SEQUENCE NOTES

 

Sequences

DATABASE SEQUENCE NOTES:

Owner - Owner of the sequence

Name - Name of the sequence

MinValue - Minimum value of the sequence

MaxValue - Maximum value of the sequence

Increment - Value by which sequence is incremented

Cycle - Does sequence wrap around on reaching limit?

Order - Are sequence numbers generated in order?

Cache Size - Number of sequence numbers to cache

Last Number - Last sequence number written to disk

select  SEQUENCE_OWNER,
 SEQUENCE_NAME,
 MIN_VALUE,
 MAX_VALUE,
 INCREMENT_BY,
 CYCLE_FLAG,
 ORDER_FLAG,
 CACHE_SIZE,
 LAST_NUMBER
from   dba_sequences
where SEQUENCE_OWNER not in ('SYS','SYSTEM')
order  by SEQUENCE_OWNER,SEQUENCE_NAME