Re: Sequence Caches

>
>I'm trying to find how sequence are cached. Specifically, are they
>per transaction or set of transactions. So if a cache had a high
>cache size of 1000 with 5 users accessing the sequence would each user
>be given there own set of 1000 sequences or would the 5 users pull
>from the 1000?
>

The sequence cache is stored in the SGA - all users see it.

So your 5 users would all pull from the same pool of numbers.

Cheers,

Pete

Peter Moore
IS Database Administrator
Sequent UK Received on Thu Jul 04 1996 - 00:00:00 CEST