Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SEQUENCE_CACHE_ENTRIES

Re: SEQUENCE_CACHE_ENTRIES

From: Van Messner <vmessner_at_netaxis.com>
Date: Mon, 27 Sep 1999 21:14:16 -0400
Message-ID: <ODUH3.2567$J66.288325@typ11.nn.bcandid.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US