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!

SCN Behavior - Oracle 11 R2

757111Mar 8 2011 — edited Mar 9 2011

My understanding of SCN
----------------------------------
SCN is a simple timing mechanism Oracle uses to guarantee the ordering of transactions, and to enable recovery from failure.

Assuming my understanding is right, we will have unique SCN generated per commit (as per Oracle Doc), even if I have more than one commit at the same time.

We have noticed something strange, during our load test (concurrent users), we have noticed flashback recovery was failed because we found same SCN assigned to more than one transaction, I am not sure about expected behavior so need experts to comment, appreciate your comments and experience.

-Dhaval R

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 6 2011

Added on Mar 8 2011

#11g, #general-database-discussions, #oracle

17 comments

556 views