What is meant by SCN in Oracle 2024?
I'll answer
Earn 20 gold coins for an accepted answer.20
Earn 20 gold coins for an accepted answer.
40more
40more
Studied at Harvard University, Lives in Cambridge, MA
the system change number (SCN) is Oracle's clock - every time we commit, the clock increments. The SCN just marks a consistent point in time in the database. A checkpoint is the act of writing dirty (modified blocks from the buffer cache to disk. The database ALWAYS has transactions going on, ALWAYS.
2023-05-11 12:11:15
评论(499)
Helpful(122)
Helpful
Helpful(2)

Harper Bell
QuesHub.com delivers expert answers and knowledge to you.
the system change number (SCN) is Oracle's clock - every time we commit, the clock increments. The SCN just marks a consistent point in time in the database. A checkpoint is the act of writing dirty (modified blocks from the buffer cache to disk. The database ALWAYS has transactions going on, ALWAYS.