Oracle System Architecture Question:

Tell me what does LGWR do?

Tweet Share WhatsApp

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 PDF Read All 36 System Architecture Questions
Previous QuestionNext Question
Explain what constitute an ORACLE Instance?What is the function of checkpoint (CKPT)?