What to do about the disorder of oracle rac sequence

Editor to share with you how to do oracle rac sequence disorder, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

Sequence creation method:

CREATE SEQUENCE [schema.] sequence

[INCREMENT BY integer]

[START WITH integer]

[MAXVALUE integer | NOMAXVALUE]

[MINVALUE integer | NOMINVALUE]

[CYCLE | NOCYCLE]

[CACHE integer | NOCACHE]

[ORDER | NOORDER]

There are three situations about the use of Sequence under Oracle:

1. Cache + noorder

2. Nocache

3. Cache + order

Problem: oracle rac is prone to confusion when creating sequences, which can be ordered in the following ways

Solution:

1. Set cache to empty

two。 Set it to order when creating the sequence, that is, use cache + order

The above is all the content of this article "what to do with oracle rac sequence disorder". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!