Interested to Buy Any Domain ? << Click Here >> for more details...
What does LGWR do?
- 2 Answers
- 5440 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravi dutta
log writer is used to write the commited or uncommited data
from the redolog buffer to the redo log file.
| Is This Answer Correct ? | 4 Yes | 0 No |
Whenever any change takes place in database,first the change is written to LOGBUFFER.Then from LOGBUFFER the changes are written to REDOLOG files.
LogWriter(LGWR) is a process that writes the redobuffers from LOGBUFFER to REDOLOGFILES in terms on change vectors.
When does Logwriter(LGWR) writes to Redologs,
-Whenever logbuffer is 1mb or 1/3rd full.
-Whenever user commits.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is an oracle database schema?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
Why query fails sometimes ?
What is an Oracle SYSTEM tablespace and when is it Created?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the function of Redo Log in Oracle?
Name the ORACLE Background Process?
When Does DBWR write to the database?
How will you monitor the space allocation ?
What is the function of checkpoint(CKPT)?
How can we plan storage for very large tables ?
Oracle General 
