ORCIDGitHubLinkedIn
RSS Curriculum Vitae TR

System Change Number

Turkish equivalent: Sistem değişiklik numarasıDomain: Oracle

Oracle's monotonically advancing logical time value used to order database changes and define consistent visibility points.

Oracle Runtime Context

The System Change Number is Oracle's monotonically advancing logical time used to order database changes and identify consistent visibility points. Redo, commit processing, consistent reads, and recovery all relate state to SCN positions rather than treating wall-clock time as the ordering primitive.

Semantics Boundary

SCN is not an application sequence number or a general timestamp substitute. Its meaning belongs to Oracle's consistency and recovery mechanisms.

Source

  • https://docs.oracle.com/en/database/oracle/oracle-database/19/cncpt/transactions.html

Updated:

Related concepts

Oracle