What does LGWR do ?

Log Writer (LGWR) writes redo log entries generated in the redo log buffer of the SGA to on-line Redo Log File.

Interview Candidate
Sep 6th, 2004
2
5149

Showing Answers 1 - 2 of 2 Answers

rajat dey

Feb 21st, 2006

hi,It is one of the main background process in oracle . In oracle and unix environment you can check this process using ps -ef |pg command . which is writting all the uncommited transaction from SGA to redologfile .regrdsrajat dey

manish hoiyani

Sep 18th, 2006

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.