Re: reg scn

Posted by ErmanArslansOracleBlog on Jun 27, 2018; 11:01am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/reg-scn-tp6293p6296.html

CONTROLFILE_CHANGE# : Last change# in backup control file.
CURRENT_SCN is the current scn.

Controlfile_change# is updated when the "controlfile" is updated. It is updated with the scn of the last control file update.

For instance, during a checkpoint, the control file is updated.. So that controlfile_change# will change. There are also other events that causes Oracle to update the controlfile..file).

SCN is Oracle's clock. So Current SCN is the current clock. Every time we commit, the SCN increments.