System Change Number (Sistem Değişiklik Numarası)

The monolithic logical clock of the Oracle database that monotonically advances with every transaction commit to coordinate MVCC consistency and recovery.

Internal Architecture Breakdown

The SCN is the foundational synchronization coordinate for Oracle read consistency, recovery checkpoints, Flashback queries, and Data Guard redo shipping. When a query starts, Oracle pins the current SCN, ensuring all read blocks reflect data state at that exact commit tick.

Tracking SCN Headroom is vital to avoid database boundary exhaustion.

Production Inspection Queries

Oracle

SELECT current_scn, scn_to_timestamp(current_scn) AS current_scn_time FROM v$database;

Back to Glossary