Sequence cache

 

select SEQUENCE_OWNER,SEQUENCE_NAME,cache_size from dba_sequences;
alter sequence SCHEMA.SEQ_NAME cache 200;

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

The Number of Entries in the Sequence Cache

When an application accesses a sequence in the sequence cache, the sequence numbers are read quickly. However, if an application accesses a sequence that is not in the cache, then the sequence must be read from disk to the cache before the sequence numbers are used.

If your applications use many sequences concurrently, then your sequence cache might not be large enough to hold all the sequences. In this case, access to sequence numbers might often require disk reads. For fast access to all sequences, be sure your cache has enough entries to hold all the sequences used concurrently by your applications.