Sequence in RAC
Problem: I created a sequence of a DB in rac: SQL> CREATE SEQUENCE PROVA_SEQ_OBJ START WITH 2001 INCREMENT BY 1 MAXVALUE 9999999999999999999999999999 MINVALUE 1 NOCYCLE CACHE 20; Values are not disconnected in sequence in the two nodes of the recommendations: instance two: SQL> SELECT USERENV(‘INSTANCE’) FROM DUAL; USERENV(‘INSTANCE’) ——————- 2 SQL> SELECT PROVA_SEQ_OBJ .nextval from dual; NEXTVAL ———- 2021 Instance one SQL> SELECT USERENV(‘INSTANCE’) FROM DUAL; USERENV(‘INSTANCE’) ——————- 1 SQL> SELECT PROVA_SEQ_OBJ. nextval from dual; NEXTVAL ———- 2001 The solution is in this oracle note: SEQUENCE: ORDER Specify ORDER to guarantee that sequence numbers are generated in order of...