Skip to Main Content

SQL & PL/SQL

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 Vs XID

user8794108Mar 14 2015 — edited Mar 14 2015
  • SCN: The system change number, or SCN, is a numeric stamp that the database automatically increments for every committed transaction that occurs in the database.
  • XID: This is the global transaction identifier.Each transaction that is executed within the database is tracked and assigneda global transaction identifier, which is essentially a transaction identification number.

  Without going into great detail, Both are increased each time a transaction is committed, SCN is to identify rows and XID is to identify Transactions, am I right ? 

   

THKS!!!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2015
Added on Mar 14 2015
2 comments
1,998 views