Skip to content

other

System Change Number

Oracle Database's monotonically increasing logical clock value, used for read consistency, commit ordering, checkpoints and recovery.

Known aliases

  • SCN

Relationships

No evidence-backed relationships are recorded.

Current clusters

build1 publisher

At least five ordering questions hide inside one updated_at column

A dev.to walkthrough of PostgreSQL snapshots, LSNs and Oracle SCNs sets out why a row version has no commit coordinate to record when it is written, and what that indirection costs the replication and audit consumers that read it later.

Publishers:dev.to

Reality

Evidence58
Adoption
Insufficient
Hype gap−8
Incentives30
Confidence58