Interested to Buy Any Domain ? << Click Here >> for more details...
How the log writer writes the data into database
- 4 Answers
- 7771 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 the role of archiever
What is the function of Lock (LCKn) Process?
What Does DBWR do?
What is a Rollback segment entry ?
What is the function of checkpoint(CKPT)?
What is a Multi-threaded Server Configuration?
What are the two types of Server Configurations?
How the log writer writes the data into database
Diference between Oracle 9i and 10G.
What is meant by free extent ?
How to find the current session sid
What are Oracle Schema Objects?
Oracle General 
