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.
Alert me