Interested to Buy Any Domain ? << Click Here >> for more details...
When does LGWR write to the database?
- 3 Answers
- 10625 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gaurav rajvanshi
1.Every 3 secs
2.At commit(when a tx commits)
3.When one third of redo log buffer is filled.
4.When there is more than 1 Mb of redo entries(redo data or
changes) in the redo log buffer
5.Before DBWR background process writes dirty buffers from
db cache to datafiles(database)
At any of the above instances(cases) lgwr writes the redo
entries or redo data or changes from the redo log buffer to
the redo log file.
| Is This Answer Correct ? | 23 Yes | 1 No |
Answer / syed alamdar ali
when one third of redo log buffer is filled.
when transcation is completed.
time out of 3 sec.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / ravi dutta
it writes the uncommited and the comited data from the
redolog buffer to the redolog file
| Is This Answer Correct ? | 10 Yes | 5 No |
How can you find the size of a database?
When will be a segment released?
What is SGA?
How will you swap objects into a different table space for an existing database?
What is Server 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 ?
When Does DBWR write to the database?
List the factors that can affect the accuracy of the estimations ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
What is the OPTIMAL parameter ?
What is meant by redo log buffer ?
Oracle General 
