Solution : https://service.sap.com/sap/support/notes/1431798 (Connexion à SAP Service Marketplace requise)
Résumé :
Cette note SAP expose les paramètres recommandés pour la configuration d'Oracle Database Release 11.2, assurant la compatibilité avec les produits SAP. Elle détaille une liste de paramètres ajustés périodiquement pour optimiser la performance et la compatibilité. Les mises à jour régulières incluent de nouvelles recommandations et des modifications des paramètres existants fondées sur une compréhension approfondie du produit et des retours des utilisateurs. De plus, des paramètres ont été dépréciés ou ajustés pour des versions et des plateformes spécifiques comme Windows 2008/2012 et Unix. Il est essentiel pour les administrateurs SAP et les DBA de suivre ces directives pour assurer un fonctionnement stable et efficace de l'environnement SAP avec des bases de données Oracle.
Mots Clés :
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
Notes associées :
| 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) |