Sequence is incremented as soon as it's asked to generate a new number; there is no rollback allowed here.

Try setting the cache_size to 1 and see what happens.

- Rajeev