What do you understand by the term 'System Change Number (SCN)'?

devquora
devquora

Posted On: Feb 22, 2018

 

For every transaction, a unique id is generated by the Oracle. This unique ID is referred to as SCN.

It is recorded whenever a change occurs in redo entry.

On every checkpoint, SCN is generated.

The numbers are updated for every 3 seconds.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Oracle DBA Interview Questions

    What do you understand by the Oracle?

    Oracle is a database company that stores the data. Oracle stores the data in a very definite way so that client can regain it in a multi-user condition...

    Oracle DBA Interview Questions

    What do you mean by Oracle Database?

    Oracle has the main theme of storing, creating and managing the database...

    Oracle DBA Interview Questions

    What do you mean by Oracle DBA and what is its role?

    DBA stands for the Database administrator. DBA has the proper rights that can add or remove new users...