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