Difference between sequence and strict sequence

I’m looking at the different sequences and see that I have two sequence possibilities.

  1. ‘normal’ sequence
  2. strict sequence

When I compare the two views, I don’t see any differences. So what are the differences?

The normal sequence generates unique number but there may be gap in the sequence (due to transaction rollback for example).
The strict sequence are guarantee to be unique and without gap (but at a cost of having a lock).

1 Like