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 the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What are the functions of SMON?
How the log writer writes the data into database
What is use of Rollback Segments In Database ?
what is ORACLE MEMORY STRUCTURES
How many Dispatcher Processes are created?
What is Database Buffers ?
Diference between Oracle 9i and 10G.
When does LGWR write to the database?
What is meant by free extent ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the maximum size of a oracle9i database?