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…
Leggi tutto

26 Giugno 2013 0