On Wed, Mar 01, 2006 at 10:17:04AM +0530, Suvarna wrote:
> actually the number which are missing are in the range of 20-30 and at the
> max only 3 transactions are going on at any given point in time.
> So if 3 numbers are missing then it was understood the missing numbers are
> very large.
The number of transactions is irrelevant. If a single transaction
obtains 20 values from a sequence and that transaction is rolled
back, then those 20 sequence values are gone. Think of a sequence
as a generator of arbitrary unique numbers, not as a way to get
numbers guaranteed to have no gaps.
--
Michael Fuhr