Understanding Oracle System Change Numbers and Their Role in Database Recovery
System Change Number (SCN) Fundamentals
The SCN (System Change Number) serves as Oracle's internal timestamp mechanism for tracking data base modifications. It represents a logical ordering point at which database changes occur, enabling the database to query and track modifications with precision.
Each transaction within Oracle follows a seque ...
Posted on Tue, 12 May 2026 23:03:21 +0000 by jumpfroggy
Apache Flink Checkpoint Configuration Guide
Prerequisites
Exactly Once Processing
For exactly once semantics to work properly:
Source systems: Must support data retransmission (e.g., message queues like Kafka, distributed file systems like HDFS)
Sink systems: Must support idempotent operations (e.g., Doris supports deduplication)
At Least Once Processing
For at least once semantics:
S ...
Posted on Thu, 07 May 2026 06:14:41 +0000 by smpdawg