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!

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,280 views