Solution : https://service.sap.com/sap/support/notes/1431798 (SAP Service marketplace login required)
Summary :
This SAP note outlines the recommended settings for Oracle Database Release 11.2 for compatibility with SAP products. It provides a comprehensive list of parameters adjusted over time to optimize performance and compatibility. Regular updates include new parameter recommendations and modifications to existing parameters based on evolving product insights and customer feedback. Additionally, some parameters have been deprecated or adjusted for specific Oracle versions and platforms like Windows 2008/2012 and Unix. It is crucial for SAP administrators and DBAs to adhere to these guidelines to ensure stable and efficient operation of the SAP landscape with Oracle databases.
Key words :
customer component bc-db-ora oracle priority recommendations / additional info category consulting validity, online redo 1st copy db_create_online_log_dest_2 '+reco' asm, __%pdfstyle%__ / } symptom oracle database parameter, single instance 'location=+<dgname>/ <dbname>/ oraarch' asm, explanation audit_file_dest <sapdata_home>/saptrace/audit - background_dump_dest, _disable_cell_optimized_backups true unix sxd 11202unix sxd 11203_date, disk groups''+arch/<dbname>/cntrl<dbname>, spfile sql> alter system set event='<event_1>', log_archive_dest_1 'location=<sapdata_home>/ oraarch/ <sid>arch', online redo 2nd copy db_file_multiblock_read_count
Related Notes :
| 1915325 | Configuration of Oracle Database Parameter 'LOCAL_LISTENER' |
| 999524 | Oracle 10.2 platform support for Async IO |
| 601157 | Oracle9i: Server Parameter File |
| 1171650 | Automated Oracle DB parameter check |
| 1289199 | Information about Oracle parameters |
| 1739274 | Database Parameter COMPATIBLE |
| 789011 | FAQ: Oracle memory areas |
| 617416 | Oracle9i: Dynamic SGA |
| 798194 | HP-UX: Trace files with async I/O error |
| 596420 | System standstill during deadlock (ORA-60) |
| 1284478 | Poor performance when using Btree bitmap plans |
| 128648 | Incorrect path used due to rounding errors |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 1565421 | Oracle 11g: dbms_redefinition may flush shared pool |
| 176754 | Problems with CBO and RBO |
| 948197 | Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x |
| 1166242 | 10g: "enq: HW contention" waits for LOB Inserts in ASSM TBS |
| 1627481 | Preemptive redolog switches in Oracle 11.2 |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 1636936 | 11g Wrong results with star_transformation_enabled = true |
| 600141 | Oracle9i: Automatic UNDO Management |
| 755342 | Incorrect execution plans with bind variable peeking |
| 1621425 | 11g Wrong results with Temp Table Transformation |
| 1887235 | Increased buffer busy waits/contention on Oracle securefiles |
| 1915485 | Wrong results on Oracle Index Organized Table (IOT's) |
| 1622837 | Secure connection of AS ABAP to Oracle via SSFS |
| 1672954 | Oracle 11g: Usage of hugepages on Linux |
| 2048023 | Oracle 11g RAC: Instance terminated with ORA-00600 [kcbo_switch_cq_1] |
| 1843967 | Oracle: Add. Information - Software Update Manager 1.0 SP09 |
| 1797748 | Oracle 11.2.0.3 underscore spare parameter |
| 1785353 | ODA 11.2.0: Patches for 11.2.0.3 |
| 1773593 | CREATE DATABASE on ASM fails with ORA-15204 |
| 1738123 | Report RSORADBA terminates with dump |
| 1720507 | |
| 1696570 | Oracle SPARC SuperCluster: Patches for 11.2.0.3 |
| 1693680 | Running SAP Software on Oracle SPARC SuperCluster |
| 1656659 | GI 11.2.0: Patches / Patch Collections for 11.2.0.3 |
| 1656654 | Exadata 11.2.0: Patches for 11.2.0.3 |
| 1641320 | NLS* parameters are marked as 'MODIFIED' in V$PARAMETER |
| 1597736 | GI 11.2.0: Patches / Patch Collections for 11.2.0.2 |
| 1595465 | MDM - Is it OLTP or OLAP? |
| 1591389 | Exadata 11.2.0: Patches for 11.2.0.2 |
| 1590515 | SAP Software and Oracle Exadata |
| 1588876 | Oracle Enhancement to add different "Mutex" wait schemes |
| 1570366 | ORA-02220 during transport |
| 1550133 | Oracle Automatic Storage Management (ASM) |
| 1527505 | Oracle 11.2.0.2 underscore spare parameter |
| 1527504 | Oracle 11.2.0.1 underscore spare parameter |
| 1525681 | Optimizer merge fix for Oracle 11.2.0.2 |
| 1506703 | Oracle 11.2 ccNUMA optimization on HP-UX |
| 1477787 | Optimizer merge fix for Oracle 11.2.0.1 |
| 1455168 | _FIX_CONTROL syntax |
| 1431800 | Oracle 11.2.0: Central Technical Note |
| 1077887 | SAP on HP-UX:mount & filesystem options for best performance |
| 1075118 | SAP on HP-UX: FAQ |
| 1013912 | FAQ: Oracle BW performance |
| 934808 | SAP Enterprise Portal on Oracle: Advanced Configuration |
| 700548 | FAQ: Oracle authorizations |
| 618868 | FAQ: Oracle performance |
| 592393 | FAQ: Oracle |
| 1974327 | Exadata 11.2.0: Patches for 11.2.0.4 |
| 1760737 | SAP Software and Oracle Database Appliance (ODA) |