From the course: Oracle 12c Database: Administration

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Checkpoint process

Checkpoint process - Oracle Database Tutorial

From the course: Oracle 12c Database: Administration

Start my 1-month free trial

Checkpoint process

- [Instructor] The next background process in our list is the checkpoint process, or CKPT in short. This process handles database checkpoints. We discussed database checkpoints briefly when we talked about the database writer background process, but let's do a quick recap. An Oracle checkpoint is a database event which synchronizes modified data blocks in memory from the buffer cache with the data files on disk. It is an event that happens regularly when the Oracle database declares a state of internal consistency, internal consistency between modifications which have been done in memory and the data that has been written to disk. A checkpoint has two purposes. One is to establish data consistency between memory and disk, and the other is to enable a faster database recovery process. Checkpoints are a crucial element in database recovery. The more database blocks we have which have been modified in memory but also have been written to disk, the less we have to rely on the redo logs…

Contents