As we discussed in the previous lesson, if
- the redo log space requests or
- the redo log space wait time values
in V$SYSSTAT are too high, there may be some waiting as concurrent Oracle processes attempt to write into the log buffer.
If redo buffer allocation retries is too high, we may want to increase the size of our redo log files.
The remedy is to increase the
parameter. The script below will show the redo log space request and the redo log space wait time. If they appear too large and your log_buffer is less than one megabyte,
then you may want to increase the log_buffer init.ora parameter.