Oracle System Architecture Question:

Download Job Interview Questions and Answers PDF

Tell me what does LGWR do?

System Architecture Interview Question
System Architecture Interview Question

Answer:

LGWR is oracle background process.. all changes which have been made inthe database gets recorded in the redolog buffer.. so when the users fires an commit statement , LGWR writes these changes it into thr redolog files. and also writes it into files when the redolog buffer is one thrid full... and also when buffer is nealy 1mb full lgwr writes it into redologfiles.

Download System Architecture Interview Questions And Answers PDF

Previous QuestionNext Question
Explain what constitute an ORACLE Instance?What is the function of checkpoint (CKPT)?