Re: SEQUENCE_CACHE_ENTRIES

The first choice.
SEQUENCE_CACHE_ENTRIES
Default value: 10
Range of values: 10 - 32000
Multiple instances: can have different values The number of sequences that can be cached in the SGA for immediate access. This cache is managed
on a least recently used (LRU) basis, so if a request is made for a sequence that is not in the cache and
there are no free entries, the oldest one on the LRU list is deleted and replaced with the newly requested
one. 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. Each entry requires approximately 110 bytes in the SGA for an Oracle7 Parallel Server.
Sequences created with the NOCACHE option do not reside in this cache. They must be written
through to the data dictionary on every use.

Van

FRANK WRIGHT <FRANK.WRIGHT_at_DAYTONOH.NCR.COM> wrote in message news:37efe3f6_at_rpc1285.daytonoh.ncr.com...
> Seem to find conflicting documentation on this initialization parameter
>
> Is it the # of sequences(cacheable) that can be cached simultaneously or
> the # of sequence values that can be cached simultaneously
>
> Regards
> FC Wright
>
>
>
Received on Mon Sep 27 1999 - 20:14:16 CDT