读书笔记 -- 《Oracle Core: Essential Internals for DBAs and Developers》 二

关于SCN到底是“System Change Number”还是“System Commit Number”。

 

还是change贴切一些。

 

There is one memory location in the SGA that is particularly worth mentioning:
the “clock” that the instance uses to coordinate its activity. This is a simple counter called
the  System Change Number  (SCN) or, not quite correctly, the System Commit Number.
Every process that can access the SGA can read and modify the SCN. Typically,
processes read the current value of the location at the start of each query or transaction
(through a routine named  kcmgss —Get Snapshot SCN), and every time a process
commits a transaction, it will increment the SCN (through a routine named kcmgas —Get
and Advance SCN). The SCN will be incremented on other occasions, which is why
System Change Number is a more appropriate name than System Commit Number.