Topic : System Change Number (SCN)

What is System Change Number (SCN)?

Answer :

- SCN is a unique ID that Oracle generates for every committed transaction.
- It is recorded for every change in the redo entry.
- SCN is also generated for every checkpoint (CKPT) occurred.
- It is an ever increasing number which is updated

Show Answer Discuss