How the log writer writes the data into database
- 4 Answers
- 6678 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 does LGWR do?
What is the role of PCTFREE parameter is Storage clause ?
Diference between Oracle 9i and 10G.
What are Oracle Schema Objects?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is the maximum size of a oracle9i database?
List the factors that can affect the accuracy of the estimations ?
What is Database Buffers ?
What is an Integrity Constrains in Oracle?
What is the function of Dispatcher (Dnnn)?
How will you force database to use particular rollback segment?
What Does DBWR do?
Oracle General 
