Interested to Buy Any Domain ? << Click Here >> for more details...
What does LGWR do?
- 2 Answers
- 5482 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 Dedicated Server Configuration?
What are the uses of Oracle Rollback Segment?
What do Redo Log Buffers contain?
What is Shared Pool?
What is the OPTIMAL parameter ?
What is an Integrity Constrains in Oracle?
What is the maximum number of Lock Processes used?
Which parameter in Storage clause will reduce no. of rows per block?
How the space utilisation takes place within rollback segments?
What is meant by Redo Log file mirrorring ? How it can be achieved?
What is the use of Oracle Control File?
How will you monitor the space allocation ?
Oracle General 
