Re: Losing sequence numbers

> John Jones <john_at_iluvatar.tip.duke.edu> writes:
> From time to time I notice that we lose some numbers in a sequence
> without the sequence being used. We have told the end user that a
> sequence just guarentees a unique number not a counter per se. Why would
> we be losing numbers????
>
> --------------------------------------------------------------------
> John Jones | my views are my own.........
> Oracle Consultant | no matter what company they are
> john_at_iluvatar.tip.duke.edu | coming from.
> --------------------------------------------------------------------
>
>>>>
John,

Have you looked at the cache defined for the sequence? I believe that, for better performance, you can define a cache of sequence numbers (ie. a batch of 20 at a time) instead of getting it one at a time. In addition, I seem to recall reading somewhere that an inappropriately set SEQUENCE_CACHE_ENTRIES initialization parameter may cause skipped sequence numbers.

I recommend that you look up the 'Sequence Cache' section in Chapter 2 of the Server Application Developer's Guide (if you haven't already done so)... there might be something thing that will help.

Good luck,
Gary Wong (gary.wong_at_cyberstore.ca)
Information Technology Consultant
(604) 360-1699 (Voice)
(604) 384-1178 (Fax) Received on Tue Jan 02 1996 - 00:00:00 CET