How the log writer writes the data into database
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 meant by redo log buffer ?
How to implement the multiple control files for an existing database ?
How will you create multiple rollback segments in a database ?
What is an oracle database schema?
What is the functionality of SYSTEM table space ?
What is an Oracle Data Dictionary?
What is the OPTIMAL parameter ?
how oracle will recognise its space is 100gb if 100gb is allocated for it...
THE MAIN CONCEPT OF PROGRAMMIN TYPE?
1.Explain the three levels with the help og a diagram.
What is the function of Lock (LCKn) Process?
What is the use of Oracle Control File?