1.

What Is Log Writer Process?

Answer»

It is responsible for writing the redo log BUFFER to a redo log file on disk. Log Writer writes all redo entries which is copied into the buffer since the last time it wrote.
When a USER issues a commit statement, Log Writer issues a commit record in the redo log buffer and writes it to disk immediately, along with the TRANSACTION’s redo entries. The corresponding changes to data blocks are delayed until it is more EFFICIENT to write them. This is CALLED a fast commit mechanism.

It is responsible for writing the redo log buffer to a redo log file on disk. Log Writer writes all redo entries which is copied into the buffer since the last time it wrote.
When a user issues a commit statement, Log Writer issues a commit record in the redo log buffer and writes it to disk immediately, along with the transaction’s redo entries. The corresponding changes to data blocks are delayed until it is more efficient to write them. This is called a fast commit mechanism.


Discussion

No Comment Found

Related InterviewSolutions