GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  System Architecture
Go To First  |  Previous Question  |  Next Question 
 System Architecture  |  Question 20 of 33    Print  
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.



  
Total Answers and Comments: 3 Last Update: October 01, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 26, 2006 04:22:56   #1  
sweety        

RE: When does LGWR write to the database ?

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.


 
Is this answer useful? Yes | No
May 24, 2006 13:25:00   #2  
Mohd Israr Khan        

RE: When does LGWR write to the database ?

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.


 
Is this answer useful? Yes | No
October 01, 2008 06:13:02   #3  
subhash.terdale Member Since: October 2008   Contribution: 11    

RE: When does LGWR write to the database ?
Log writer writes
* when transaction commits
* every three seconds
* when 1/3 of redo full
* when 1mb of redo generated
* before dbwn writes

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape