Solution : https://service.sap.com/sap/support/notes/1888485 (SAP Service marketplace login required)
Summary :
This SAP Note provides configuration recommendations for Oracle Database 12c Release 1 (12.1) specifically tailored for SAP NetWeaver-based products. Guidelines include a series of parameter setting instructions proven effective for SAP environments, though they may serve as initial references for non-NetWeaver-based platforms without guaranteed results. It emphasizes the importance of regularly reviewing and updating these settings, especially following new database patches, to maintain optimal database performance and stability. The note also details various changes and updates to parameters over time with corresponding impacts highlighted.
Key words :
temp files db_create_online_log_dest_1 '+data' online redo log 1st copy db_create_online_log_dest_2 '+reco' online redo log 2nd copy db_recovery_file_dest '+reco' disk group, disk groups db_create_file_dest '+data' - db_create_online_log_dest_1 '+data' - db_create_online_log_dest_2 '+reco' - db_recovery_file_dest '+reco' - log_archive_dest_1 'location=+<dgname>/<dbname>/oraarch', set pagesize 5000 set linesize 128 col ksppinm format a50 col ksppstvl format a40 col, control_management_pack_access oracle diagnostic packoracle tuning pack diagnostic+tuning oracle diagnostics pack includes automatic performance diagnostics, sap note 1915325 log_archive_dest_1 'location=<sapdata_home>/oraarch/<sid>arch' - undo_tablespace psapundo sap note 600141 database parameter settings, rac oracle real application clusters database rac/fs oracle real application clusters database, oracle exadata log_buffer >= 128mon oracle sparc supercluster log_buffer >= 128m _file_size_increase_increment 2143289344 required, description si oracle single instance database si/fs oracle single instance database, sql syntax parameter command event syntaxsql> alter system set event= '<event_1>', set pages 1000set lines 200column sid format a10column
Related Notes :
| 2258559 | |
| 2240098 | |
| 2178980 | Using Oracle Database In-Memory with SAP NetWeaver based Products |
| 2159551 | |
| 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 |
| 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 |
| 1035137 | Oracle Database 10g: Automatic Undo Retention |
| 981875 | Optimizer merge fix for Oracle 10.2.0.2 |
| 1165319 | Optimizer merge fix for Oracle 10.2.0.4 |
| 2005311 | |
| 1588876 | Oracle Enhancement to add different "Mutex" wait schemes |
| 755342 | Incorrect execution plans with bind variable peeking |
| 1887235 | Increased buffer busy waits/contention on Oracle securefiles |
| 2138262 | Oracle Database 12c Advanced Compression for SAP Systems |
| 740897 | Info about the Oracle license scope; Required Oracle options |
| 1028068 | Required Oracle options for the DBA Cockpit |
| 1915325 | Configuration of Oracle Database Parameter 'LOCAL_LISTENER' |
| 600141 | Oracle9i: Automatic UNDO Management |
| 798194 | HP-UX: Trace files with async I/O error |
| 1672954 | Oracle 11g: Usage of hugepages on Linux |
| 1914631 | Central Technical Note for Oracle Database 12c Release 1 (12.1) |
| 2290084 | SAP Software and Oracle Database Appliance Version 12.1 |
| 1590515 | SAP Software and Oracle Exadata |
| 1915316 | Database: Patches for 12.1.0.2 |
| 1550133 | Oracle Automatic Storage Management (ASM) |
| 2254866 | Using Oracle Database 12c Automatic Data Optimization with SAP NetWeaver |