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 - Oracle Database Tutorial
From the course: Oracle 12c Database: Administration
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.