Today, I am going to process a piece of data and discover a problem in the Oracle sequence. I am prepared to clarify this problem in the spirit of discovering, solving, and asking the root question.
Today, I am going to process a piece of data and discover a problem in the Oracle sequence. I am prepared to clarify this problem in the spirit of discovering, solving, and asking the root question.
Today, we have processed a piece of data and found a problem in the Oracle sequence. We are prepared to clarify this problem in the spirit of discovering, solving, and answering the problem.
Problems and phenomena:
For sequences, seq is obtained every time according to our understanding. nextval, Which is auto-incrementing, must be larger than the first database, but one of my log tables has the following symptoms:
LOGIDCREATETIME
17300092011/8/6 15:41:14
27299882011/8/6 15:37:53
37299782011/8/6 15:34:53
47299612011/8/6 15:43:22
57299582011/8/6 15:33:52
67299512011/8/6 15:31:38
77299442011/8/6 15:11:00
87299412011/8/6 15:10:30
Note the following red content to check whether the time and sequence size are misplaced. Among them, the time is correct and the execution sequence is the same as that of me.