Sequence cache option
SQL> SQL> -- the cache option specifies how many sequence values will be stored in memory for faster access SQL> SQL> SQL> CREATE SEQUENCE mySequence 2 MINVALUE 1 3 MAXVALUE 999999999999999999999999999 4 START WITH 1 5 INCREMENT BY 1 6 CACHE 20; Sequence created. SQL> SQL> select mySequence.nextval from dual; NEXTVAL ---------- 1 SQL> select mySequence.nextval from dual; NEXTVAL ---------- 2 SQL> select mySequence.nextval from dual; NEXTVAL ---------- 3 SQL> select mySequence.nextval from dual; NEXTVAL ---------- 4 SQL> SQL> drop sequence mySequence; Sequence dropped. SQL> SQL>