Re: Caching of Sequence Numbers.
Date: Mon, 21 Jun 1999 18:45:51 GMT
Message-ID: <zLvb3.41843$Fz2.5514_at_news.rdc1.az.home.com>
It is possible, yes, especially if you have more sequences in use than will fit in your system-wide sequence cache. Then you will get gaps, yes.
Rob Nelson <rob.nelson_at_pnl.gov> wrote in message
news:376E84D6.B3FBA199_at_pnl.gov...
> When not setting the value of the sequence number cache, it defaults to
> 20. We noticed in operation that we were seeing "holes" in our sequence
> generated numbers. The holes would be about 20 numbers in size. The
> Oracle docs indicate that sysem failure will cause you to lose the
> cached values for sequence numbers. Is this also the case if you have a
> significant period of time between accesses to the sequence numbers that
> are cached? That is, will the sequence numbers be swapped out of cache?
>
>
>
> Seq. Access Time
> #
> 32122 6/21/99 9:53:56 AM
> 32121 6/21/99 9:04:44 AM
> 32102 6/21/99 8:48:34 AM
> 32101 6/21/99 8:05:59 AM
> 32081 6/21/99 12:00:12 AM
> 32063 6/19/99 8:18:18 PM
> 32062 6/19/99 7:14:53 PM
> 32061 6/19/99 6:52:39 PM
> 32041 6/19/99 6:14:12 PM
> 32023 6/19/99 1:22:37 PM
> 32022 6/19/99 1:06:12 PM
> 32021 6/19/99 12:41:17 PM
> 32002 6/19/99 10:48:23 AM
> 32001 6/19/99 10:46:02 AM
>
> Rob
>
Received on Mon Jun 21 1999 - 20:45:51 CEST