Number of redo entries per redo log space requests
run various SAP systems on Oracle 220.127.116.11 (ERP 2004, BI 7.0. PI 7.0,
SRM 4.0, SOLMAN 7.01 )
I have numerous alerts every day as per below, in most of these systems
Redo log buffer [ 10 Alerts ], 2.288 < 4.000 redo entries per redo
log space requests
Redo log buffer
Cause: The number of redo entries per redo log space request fell below
the configured threshold.
Oracle recommends at least 5000 redo entries per redo log space request.Action: Increase the size of the redo log buffer by increasing the
log_buffer until the number of redo entries per redo log space request
stops increasing. .
However, when I upgraded to Oracle 11, in note 1431798 - Oracle
11.2.0 : Database parameter settings ,
it reads that we shouldn't be setting the LOG_BUFFER value and to use
the default. The default set automatically by Oracle in my systems is between 16M and 21M
In addition, I do not understand how increasing the size of the redo log buffer would make the number of redo entries per redo log space request bigger. I understand that a redo log space request is a redo log switch, which will happen as soon as the respective redo log fills up and I do not see how this relates to the size of the redo log buffer itself.
Please let me know what you think