What is the use of checkpoint in Oracle 2024?

Charlotte Martin | 2023-05-05 12:11:14 | page views:1541
I'll answer
Earn 20 gold coins for an accepted answer.20 Earn 20 gold coins for an accepted answer.
40more

Lucas Kim

Works at the United Nations Office on Drugs and Crime, Lives in Vienna, Austria.
Oracle Checkpoint. A checkpoint performs the following three operations: Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk. It's the DBWR that writes all modified databaseblocks back to the datafiles.
2023-05-11 12:11:14

Amelia Wilson

QuesHub.com delivers expert answers and knowledge to you.
Oracle Checkpoint. A checkpoint performs the following three operations: Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk. It's the DBWR that writes all modified databaseblocks back to the datafiles.
ask:3,asku:1,askr:137,askz:21,askd:152,RedisW:0askR:3,askD:0 mz:hit,askU:0,askT:0askA:4