Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Number of redo entries per redo log space requests

Hello all,

run various SAP systems on Oracle 11.2.0.1 (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

In

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/45/e2467adee64ebee10000000a11466f/frameset.htm

I read:

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

init<DBSID>.ora parameter

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

Many thanks

Andreas

Not what you were looking for? View more on this topic or Ask a question