Oracle - Explain how to tune the Redo log buffer. posted by
Babu Kunwar
Explain how to tune the Redo log buffer.
Redo log buffer is used for logging the events that has happened in database,
that is it is used for keeping the track of changes that is taking place to a
particular database. The information details of the events are stored inside
redo entries which is necessary for undo the changes that has been made to
database.
Steps to tune:
-
Determine the size of the Redo Log Buffer using LOG_BUFFER parameter.
-
Determine the number of waits which must be equal to zero. If not increase the
size of buffer to make it zero.
-
Then determine how long processes had to wait as well as the number of times.
These above steps would help in tuning of the Redo log buffer.
More links
Overview of PL/SQL Error Handling
Advantages of PL/SQL Exceptions
Explain some of the commonly used Predefined PL/SQL Exceptions.
What is user-defined exception? Explain it with an example.
Explain how PL/SQL exceptions are raised..........
|
