Commit Sequence Number [CSN]

We know that all database management system maintains some kind of unique auto incremental number of its own at the completion of each transaction like we have SCN number in Oracle database. With that number, we can uniquely identify that transaction.

With reference to the above description, We can say that Commit Sequence Number is an identifier that Oracle GoldenGate constructs to identify a source transaction.

CSN number is processed in a platform-independent manner. It helps to maintain transactional sequence and data integrity.

We can find a particular point in time with the CSN number.

We can see CSN number is: 1872060. We can check here replicat detail of rep2 shows us Last Committed Transaction sequence number 1872060. Data is replicated until that sequence number.

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.