When does LGWR write to the database?
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 |
List the factors that can affect the accuracy of the estimations ?
Which parameter in Storage clause will reduce no. of rows per block?
How will you monitor the space allocation ?
What is an Oracle Data Segment?
What is advantage of having disk shadowing/ Mirroring ?
How the space utilisation takes place within rollback segments?
How can we plan storage for very large tables ?
What is the role of PCTFREE parameter is Storage clause ?
How will you create multiple rollback segments in a database ?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
What is dictionary cache ?
What is an Oracle Data Block?