Oracle Sequences in RAC environment
Hi All,
In one of our projects(10.2.0.4, 2 node RAC) , we have the client DBA team that helps us
extensively on all the dba activities. Recently, while checking some performance issues, a
developer noticed that the sequences are created with nocache(or cache with a low number), and
'order' and had approached me for suggestions if we can modify them to improve performance. The dba
team has checked with Oracle support on the need for 'order', it appears that Oracle has come out
saying that if 'noorder' is used then duplicate numbers could be generated for the same sequence
from different
0