Interested to Buy Any Domain ? << Click Here >> for more details...
How the log writer writes the data into database
- 4 Answers
- 7793 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 an Oracle Rollback Segment?
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
How can we plan storage for very large tables ?
List the factors that can affect the accuracy of the estimations ?
What is Dedicated Server Configuration?
How can you find the size of a database?
What are the two types of Server Configurations?
What is the maximum number of Lock Processes used?
How many Dispatcher Processes are created?
What is the maximum size of a oracle9i database?
1.Explain the three levels with the help og a diagram.
How to find the current session sid
Oracle General 
