Login  Register

Re: reg scn

Posted by ErmanArslansOracleBlog on Jun 27, 2018; 2:18pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/reg-scn-tp6293p6307.html

My statement is clear.
Every time we commit, SCN increments.

Here is what Tom Kyte says ->

scn's are written to redo logs continuously - when you commit they are emitted into the redo stream.
and semantically speaking, after the checkpoint COMPLETES, not after the checkpoint is INITIATED..

Ref: https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:48052838748707