Fast access to all sequence numbers - Features, Properties - Oracle Views, Sequences, and Synonyms

Q.  What are the following guidelines used for?

1) Be sure the sequence cache can hold all the sequences used concurrently by your applications
2) Increase the number of values for each sequence held in the sequence cache

- Published on 04 Aug 15

a. Slow access to all sequence numbers
b. Fast access to all sequence numbers
c. Neutral
d. All mentioned above

ANSWER: Fast access to all sequence numbers
 

    Discussion

  • Nirja Shah   -Posted on 29 Sep 15
    - Sequence numbers can be kept in the sequence cache in the System Global Area (SGA).

    - Sequence numbers can be accessed more quickly in the sequence cache than they can be read from disk.

    - The sequence cache consists of entries. Each entry can hold many sequence numbers for a single sequence.

    - Follow these guidelines for fast access to all sequence numbers:

    1. Be sure the sequence cache can hold all the sequences used concurrently by your applications.

    2. Increase the number of values for each sequence held in the sequence cache.

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)