Archive for

Oracle SCN – The Concept

1. What is scn? SCN to identify the database at a precise moment commit. When a transaction is committed, it is given a unique identifier transaction SCN. SCN at the same time as the internal clock mechanism for Oracle database, can be seen as logical clocks, each database has a global SCN generator. SCN (System … Continue reading

Oracle SCN – In Details

SCN(system change number) in Oracle Database System and the time of our lives meaning are the same, SCN is Oracle in time number. Why Oracle not use Operation System time to define it? If I perform a DML in the US New York Time at 8:00, and then modify the OS time of the machine … Continue reading