Interested to Buy Any Domain ? << Click Here >> for more details...
What does LGWR do?
- 2 Answers
- 5674 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 |
How the space utilisation takes place within rollback segments?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
What is Server Process?
• What is oracle Architecture?
How will you monitor rollback segment status ?
When will be a segment released?
Name the ORACLE Background Process?
Which parameter in Storage clause will reduce no. of rows per block?
What is a Parallel Server option in ORACLE?
What is User Process?
What is meant by Redo Log file mirrorring ? How it can be achieved?
How to implement the multiple control files for an existing database ?
Oracle General 
