What is System Change Number (SCN)?
@ : Home >
> Interview Room
- SCN is a unique ID that Oracle creates 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 for every 3 seconds
- You can get the SCN number by querying select SCN from a v$database from SQLPLUS.