Name
SEQUENCE_CACHE_ENTRIES
Synopsis
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.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.