How the log writer writes the data into database
- 4 Answers
- 6315 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 Shared Pool?
What is an Integrity Constrains in Oracle?
What is the function of Dispatcher (Dnnn)?
How will you monitor the space allocation ?
What is meant by recursive hints ?
What is a Rollback segment entry ?
• What is oracle Architecture?
What is a Multi-threaded Server Configuration?
What is User Process?
What is advantage of having disk shadowing/ Mirroring ?
Diference between Oracle 9i and 10G.
What is the OPTIMAL parameter ?
Oracle General 
