Let's learn what the system change number (scn) does in Oracle Database.
When any of SQLs run, the database converts the timestamp value to a number it can detect. This number is called system change number, SCN for short. System change number is used by the database to ensure data consistency. You can watch the video for more information about System Change Number (SCN).
#oracle #oracledatabasetutorial #oracledba
Download
0 formats
No download links available.
What is System Change Number (SCN) ? - Oracle Database DBA Tutorial | NatokHD