Interested to Buy Any Domain ? << Click Here >> for more details...
How the log writer writes the data into database
- 4 Answers
- 7572 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 to find the SGA Size
What is advantage of having disk shadowing/ Mirroring ?
What is User Process?
How the space utilisation takes place within rollback segments?
What is the function of checkpoint(CKPT)?
What is an Oracle Data Dictionary?
What is an Integrity Constrains in Oracle?
How does Space allocation table place within a block ?
How to find the current session sid
What is a Parallel Server option in ORACLE?
1.Explain the three levels with the help og a diagram.
What is hit ratio ?
Oracle General 
