ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
Google
 
Categories  >>  Software  >>  Databases  >>  Oracle  >>  Architecture
 
 


 

 
 Oracle General interview questions  Oracle General Interview Questions
 OCI interview questions  OCI Interview Questions
 Architecture interview questions  Architecture Interview Questions
 Oracle Security interview questions  Oracle Security Interview Questions
 Database Management interview questions  Database Management Interview Questions
 Forms Reports interview questions  Forms Reports Interview Questions
 Oracle AllOther interview questions  Oracle AllOther Interview Questions
Question
When does LGWR write to the database?
 Question Submitted By :: Guest
I also faced this Question!!     Rank Answer Posted By  
 
  Re: When does LGWR write to the database?
Answer
# 1
it writes the uncommited and the comited data from the
redolog buffer to the redolog file
 
Is This Answer Correct ?    0 Yes 2 No
Ravi Dutta
 
  Re: When does LGWR write to the database?
Answer
# 2
when one third of redo log buffer is filled.
when transcation is completed.
time out of 3 sec.
 
Is This Answer Correct ?    1 Yes 0 No
Syed Alamdar Ali
 
 
 
  Re: When does LGWR write to the database?
Answer
# 3
1.Every 3 secs
2.At commit(when a tx commits)
3.When one third of redo log buffer is filled.
4.When there is more than 1 Mb of redo entries(redo data or
changes) in the redo log buffer
5.Before DBWR background process writes dirty buffers from
db cache to datafiles(database)

At any of the above instances(cases) lgwr writes the redo
entries or redo data or changes from the redo log buffer to
the redo log file.
 
Is This Answer Correct ?    1 Yes 0 No
Gaurav Rajvanshi
 

 
 
 
Other Architecture Interview Questions
 
  Question Asked @ Answers
 
What is SGA?  1
What is the functionality of SYSTEM table space ?  2
How will you monitor the space allocation ?  2
How can we plan storage for very large tables ?  1
How to find the SGA Size  2
What is a Control file ?  2
What is a Parallel Server option in ORACLE?  1
What constitute an ORACLE Instance?  2
What is advantage of having disk shadowing/ Mirroring ?  1
What is the function of checkpoint(CKPT)?  1
What are disadvanteges of having raw devices ?  1
What is the role of PCTFREE parameter is Storage clause ?  2
What is the function of Lock (LCKn) Process?  1
When Does DBWR write to the database?  4
How will you create multiple rollback segments in a database ?  1
What is Database Buffers ?  2
What is the function of Dispatcher (Dnnn)?  2
How to find the current session sid  2
what is ORACLE MEMORY STRUCTURES  1
How to implement the multiple control files for an existing database ?  1
 
For more Architecture Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com