Interested to Buy Any Domain ? << Click Here >> for more details...
How the log writer writes the data into database
- 4 Answers
- 7625 Views
- Baidu, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sunny
when log writer 1/3 fill, commit occurs, timeout every 3
second, checkpoint occur.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / ashok
logfile is 1/3 full
for every 3 seconds
there are more than imb changes occured in logbuffer
commit occur
before dbwr write durtybuffers to datafiles
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / karthickumar pillaiyarsamy
Log writer Writes when,
1. 1/3 fill of RLBC
2. 1MB fill
3. every 3 seconds
4. used Commit Statement
5. Before DBWn writes
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / veeravel.csv@gmail.com
LGWR writes:
• At commit
• When one-third full
• When there is 1 MB
of redo
• Every 3 seconds
• Before DBWn
writes
| Is This Answer Correct ? | 1 Yes | 2 No |
What is an Oracle Rollback Segment?
What is the functionality of SYSTEM table space ?
Can a View based on another View in Oracle?
How can you find the size of a database?
What is the function of Redo Log in Oracle?
How will you create multiple rollback segments in a database ?
How will you monitor the space allocation ?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is meant by recursive hints ?
What is PGA?
How to find the SGA Size
How will you force database to use particular rollback segment?
Oracle General 
