CODEWITHSUNDEEP
oracle10gsequencesid-generation
cascadox
cascadox

Reputation: 893

Sequence increment by 50 instead of 1

I created an Oracle sequence:

Create sequence seq_acteurs start with 1 increment by 1;

Normally the sequence must be incremented by 1, but when insert into Acteurs table, the sequence s incremented by 50! That doesn't seem logical. Why is this so?

Any help will much apreciated.

Upvotes: 8

Views: 9557

Answers (3)

diego matos - keke
diego matos - keke

Reputation: 2109

In your entity class add this and will increase by 1

allocationSize=1

this is an example: 

@SequenceGenerator(name = "ECP_EVALUACION_SEQ", sequenceName = "SCORTN.ECP_EVALUACION_SEQ",allocationSize=1)

Upvotes: 3

oluies
oluies

Reputation: 17831

Sequences does not guarantee that they generate a gap free sequence of numbers.

You can minimize the gaps by specifying nocache, but this does still not guarantee gap free sequences, and might create a resource contention.

Example from the documentation:

CREATE SEQUENCE customers_seq START WITH 1000 INCREMENT BY 1 NOCACHE NOCYCLE;

Upvotes: 3

Basanth Roy
Basanth Roy

Reputation: 6490

Sequence numbers are not fetched one at a time when you need them. NOrmally, the DB caches a certain number of sequence numbers in memory. WHen the cached sequences are all used up, then the DB fetches a new block of sequence numbers into cache. Now if the DB crashes for some reason while the cache still has some unused numbers, then there could be some gaps in your sequence numbers.

Upvotes: 4

Related Questions