Consult the:
Oracle 11 g, 22:00 PM, SYS_AUTO_SQL_TUNING_TASK executes, for an insert statement (insert into t1. The select seq_xxx nextval,? ,? . ) tuning, can you tell me the end of the call, seq_xxx current sequence value will change?

CodePudding user response:

Will become the next,,,,

CodePudding user response:

The

refer to the original poster p2p1024 response:

to ask:
Oracle 11 g, 22:00 PM, SYS_AUTO_SQL_TUNING_TASK executes, for an insert statement (insert into t1. The select seq_xxx nextval,? ,? . ) tuning, can you tell me the end of the call, seq_xxx current sequence value will change?

Query the current sequence value use: the select seq_xxx currval from dual;
Sequence of each call, the current value will change,

CodePudding user response:

Select seq_xxx. Nextvalfrom mytable, XXX. Nextval would change, if there are 10 of mytable records, XXX. Currval will increase 10,

CodePudding user response:

This problem or did you do a test is better, in theory, I think I should change, because some tuning tool may need to actually execute the statement

CodePudding user response:

Where the significance of the problem is, wrenched the meaning of sequence