What is System Change Number (SCN)?

@ : Home > > Interview Room
  • 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 for every 3 seconds
  • You can get the SCN number by querying select SCN from the v$database from SQLPLUS.

 

Alert me