Solution : https://service.sap.com/sap/support/notes/1888485 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP présente des recommandations de configuration pour Oracle Database 12c Release 1 (12.1), spécialement conçues pour les produits basés sur SAP NetWeaver. Elle comprend une série d'instructions de paramétrage éprouvées efficaces pour les environnements SAP, pouvant également servir de références initiales pour les plateformes non basées sur NetWeaver sans résultat garanti. L'importance de revoir et de mettre à jour régulièrement ces paramètres est soulignée, particulièrement après l'introduction de nouveaux correctifs de base de données, pour maintenir des performances et une stabilité optimales. La note détaille également divers changements et mises à jour de paramètres au fil du temps, avec les impacts correspondants mis en évidence.
Mots Clés :
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
Notes associées :
| 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 |