When does LGWR write to the database ?

LGWR   writes  redo  log  entries  into  an  on-line  redo  log  file  when transactions commit and the log buffer files are full.
  • Interview Candidate
  • 5
  • 10970

Showing Answers 1 - 5 of 5 Answers

sweety

  • Apr 26th, 2006
 

LGWr writes when:

1)at commit

2)when 1/3rd full

3)when there is 1mb of redo

4)every 3 seconds

5)before DBWn writes.

Mohd Israr Khan

  • May 24th, 2006
 

The LGWR   writes  redo  log  entries  into  an  on-line  redo  log  file  when

1. transaction is committed.

2. More than 1 MB of redo log buffer enteries.

3.  1/3 of the redo log buffer is full.

4. Every 3 seconds.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions