The ORDER clause is a performance killer for sequences in Oracle RAC. This clause will guarantee that the NEXTVAL is in order from the prevIoUs value no matter which instance is asking for the next value. For an active sequence,this means there will be lots of chatter on the Cluster Interconnect. Also,if you use ORDER,then it is worse than NOCACHE (another performance killer for active sequences in Oracle RAC).
