Re: View current seq. no.

From: Tim london <tim_at_nospam.artemis.demon.co.uk>
Date: Fri, 14 May 99 08:15:45 GMT
Message-ID: <926669546.15230.0.nnrp-04.9e981037@news.demon.co.uk>

The wat I believe sequences work is that a nmber of values are cached in the SGA, for instance if you cache to 10 then the next 10 values are held in the SGA, users will then be allocated numbers from the cache on a first come first served basis untill the 10 numbers are used than 10 more will be generated.

This can be demonstrated by allocating a few numbers and then shutting the database down, the sequence will now recache, giving a gap.

Tim London Received on Fri May 14 1999 - 03:15:45 CDT