What does LGWR do?
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 advantage of having disk shadowing/ Mirroring ?
How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is an Oracle Rollback Segment?
What are the components of SGA?
How to find the SGA Size
How can we plan storage for very large tables ?
What Does DBWR do?
How the space utilisation takes place within rollback segments?
Why query fails sometimes ?
How does Space allocation table place within a block ?
What does LGWR do?