Synopsis

Values:10 to 32000

Default:10

Specifies the number of sequence values allowed to be cached in the SGA for immediate access. The highest concurrency is achieved by setting this value to the highest possible number of sequences that will be used on an instance at once. For a parallel server, each entry requires approximately 110 bytes in the SGA. Sequences created with the NOCACHE option do not reside in this cache, and must be written through to the data dictionary on every use.