SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in Sequence

565738Jul 26 2007 — edited Jul 27 2007

Type: Production database
Instances : 2 [glfo1,glfo2]

Problem Summary:

In our setup, Application runs only from Instance 1[glfo1].

Sequence are getting generated for every "insert statement".Current cache size for the sequence is 20.

And we found some sequences are in jumbled order.

for example

Day 1 : Sequence generated 21,22,23,24,30,31,32
Day 2: Sequence generated 25,26,27,28,29,33,34,35,36

Can Any one help in this ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 24 2007

Added on Jul 26 2007

26 comments

909 views