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.
| Previous Question | Next Question |
| Explain what constitute an ORACLE Instance? | What is the function of checkpoint (CKPT)? |