checkpoints Archives -

Oracle Log Switches and Checkpoints

15/10/2012 by Philip

When a redo log file fills up it switches to the next file. This is called a log switch. The log switch always causes a checkpoint to occur. This flushes all dirty buffers from the log cache. (writes modified data to disk) If archiving is on, the old log file id archived. The new log …

Oracle Checkpoints

11/10/201211/10/2012 by Philip

When the data in a oracle database needs to be changed, it has to be done quickly. Accessing the data files on disk is slow and so, all changes in the Oracle database are carried out in the buffer cache and are only written to files at a later point by the DBWR. The buffer …