Skip to Main Content

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!

Multiple Transcation with one SCN

2700315Jul 11 2014 — edited Jul 14 2014

Hi,

one question:
If I run one statement that has multiple transactions I'll have one SCN with multiple Transaction ID.

How is this writen to the redolog? Will I find "datasets" with the same SCN and different Transaction IDs?

In case of recocery the Statement will be "redone" ordered by SCN and within SCN by Transaction Id?

I didn't find any Docs about that one


Regards
Christian

This post has been answered by Martin Preiss on Jul 11 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 11 2014
Added on Jul 11 2014
23 comments
6,413 views