Sequence Caches

From: John Dennis <jtdennis_at_atl.mindspring.com>
Date: 1996/07/03
Message-ID: <4rdsp4$1bea_at_mule2.mindspring.com>#1/1


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?

I'm trying to figure this out because I'd like to set my cache size high because I know that a session will use them but if each user pull this high amount then my sequence will increment quickly.

Thanks for any input.

Virtually,

John Dennis  

John Dennis
Tactics, Inc
Atlanta, GA Received on Wed Jul 03 1996 - 00:00:00 CEST

Original text of this message