SAP BASIS

Symptom This note contains SAP's recommendations for the optimal configuration of Oracle Database Release 11.2. These parameter recommendations are relevant for all SAP products. This note will be updated regularly once a month. Beyond that, changes will only be made in exceptional cases for critical Oracle parameters. Change history: October 27, 2011: add WIN 11.2.0.1 to _OPTIMIZER_USE_CBQT_STA..

Symptom This note describes how to set events when the Oracle database was started with SPFILE. Other terms event, events, init.ora, init.ora, SPFILE, parameter, Oracle 9i, server parameter fileReason and Prerequisites You are using Oracle 9i or higher and you are using the SPFILE (= binary server side parameter file) as parameter file.Solution (For further information on SPFILEs, see SAP Note 6..