Managing DB Objects
Cycles Redo Log Files
Redo Log Info
Extract TS Information
Archive Log List
CKPT Checkpoint Process
dbw0 Database Writer
Writing Dirty Buffers
Oracle Process Monitor
Database Buffer Cache
Oracle Shared Pool
Redo Log File Sizes
Oracle redo log buffer
1) Server processes create redo log entries as they change blocks in database buffer cache.
2) As redo log entries are created, they are placed in the redo log buffer
3) The log writer's job is to write the redo log entries to the redo log files as fast as possible.
4) Log writer continuously pulls entries from the head of the redo log buffer, and writes those entries to a redo log file.
5) Even as entries are being written, more are being generated
6) When one log file fills, logwriter switches to another
7) This process continues for as long as the database is running