How the log writer writes the data into database
- 4 Answers
- 6995 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 |
How can you find the size of a database?
What is the maximum size of a row in oracle 9i?
4 Answers Baidu, HCL, Yashu Systems,
Why query fails sometimes ?
What is the function of Dispatcher (Dnnn)?
What is the role of PCTFREE parameter is Storage clause ?
How the space utilisation takes place within rollback segments?
How free extents are managed in Ver 6.0 and Ver 7.0 ?
What is Shared Pool?
List the Optional Flexible Architecture (OFA) of Oracle database ?
How to find the SGA Size
What is SGA?
What is meant by Redo Log file mirrorring ? How it can be achieved?
Oracle General 
