Geek asks and answers

Sequence increment of 50 instead of 1

I created an Oracle sequence:

Create a sequence of seq_acteurs begins with 1 increment by 1;

Usually the sequence should be increased by 1, but when inserted into the table, the Acteurssequence sincreases by 50! This does not seem logical. Why is this so?

Any help would be greatly appreciated.

+3
source share
3 answers

, . NOmally, DB . , . , DB - , , .

+3

, .

, nocache, .

:

CREATE SEQUENCE customers_seq   1000  INCREMENT BY 1  NOCACHE  NOCYCLE;

+2

1

allocationSize=1

that's an example:

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

More articles:


All Articles