Interested to Buy Any Domain ? << Click Here >> for more details...
How the log writer writes the data into database
- 4 Answers
- 7810 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 are the two types of Server Configurations?
What Does DBWR do?
What is an Oracle SYSTEM tablespace and when is it Created?
Diference between Oracle 9i and 10G.
What is a Parallel Server option in ORACLE?
What is the significance of having storage clause ?
what is ORACLE MEMORY STRUCTURES
What do Redo Log Buffers contain?
Which parameter in Storage clause will reduce no. of rows per block?
• What is oracle Architecture?
What is Database Buffers ?
Name the ORACLE Background Process?
Oracle General 
