Oracle System Architecture Question:
Download Job Interview Questions and Answers PDF
Tell me what does LGWR do?
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 Question | Next Question |
Explain what constitute an ORACLE Instance? | What is the function of checkpoint (CKPT)? |