Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

What generates new SCN ? A command or a transaction ?

593075Oct 14 2007 — edited Oct 14 2007

Hello,

can you explain me please: When is a new SCN generated ? Only per transaction or per single SQL statement ? Sometimes i read that SCN's are issued per transaction, but i'm not sure if thats correct.

If one issues lets say 5 DML SQL statements (inserts, deletes) within one transaction, how may unique SCN's will be generated ? One for the whole transaction or 5 ?

And don't need "select" SQL statements also to have a SCN in order to get a read consistent image ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2007

Added on Oct 14 2007

#general-database-discussions

10 comments

1,229 views