December 2002
Intermediate to advanced
928 pages
85h 29m
English
SEQUENCE_CACHE_ENTRIES
Value: 10-32000
Default: 10
Specifies the number of sequences that can be cached in the SGA for immediate access. The highest concurrency is achieved when this value is set to the highest possible number of sequences that will be used on an instance at one time. Sequences created with the NOCACHE option do not reside in this cache and are written through to the data dictionary on every use. Obsolete with Oracle8i.