This content has been marked as final. Show 3 replies
I have been reading that the column xid$$ (transaction id) in the log uniquely identifies the transaction that made the changes to the row. So if I create the log on these 3 tables, will it record the same xid$$ value for changes that were made during the single process?
Don't be afraid of breaking Oracle by actually trying things! (With the obvious exception of manually altering the data dictionary or SYS objects)
Thanks. My initail tests seem to indicate that values are the same. Just wanted someone to confirm if they knew.
And now you know. A transaction, once begun, is ended when either a COMMIT or ROLLBACK is executed (either explicitly or implicitly).
MV log updates are performed as part of a transaction. There could be multiple transactions updating the MV log at the same time but they will have different transaction IDs. The transaction Id is analogous to an SCN.