Control Log Switches and Checkpoints
As a DBA, it is important for you to know how to control log switches and checkpoint frequency. This section provides information on how to do this.
Log Switches
Log writer writes to the online redo log files sequentially. When the current active online redo log group is filled, log writer begins writing to the next group. This is called a log switch. When the last online redo log available is filled, LGWR returns to the first redo log group and starts the process all over again.
Checkpoints
During a checkpoint, a number of dirty database buffers (buffers whose contents haven't yet been written out to disk) covered by the redo log file that is being checkpointed are written to the data files by DBWn. This ...
Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
