Oracle RAC Tuning Sequences

Sequences in RAC environments encounter much less contention when a large cache is used and the sequence is defined as “noorder”.

alter sequence seq1 cache 10000 noorder;

Scroll to Top