Solution : https://service.sap.com/sap/support/notes/830576 (Connexion à SAP Service Marketplace requise)
Résumé :
This SAP note provides comprehensive guidelines for configuring Oracle Database 10g within SAP environments. It addresses the maintenance of server parameter files (SPFILE) and initialization parameters, offering a uniform configuration recommendation across different system types as of Release 10g. Additionally, it includes directions for cleaning obsolete parameters and not setting unnecessary ones unless specifically mentioned. Detailed advice is also given for parameter maintenance with SFILEs and handling multiple EVENT parameters in `init.ora`. Recommendations vary based on system types (OLTP, OLAP), and dynamic SGA and automatic PGA management features are highlighted.
Mots Clés :
memory processes #abap work processes 2 + #j2ee server processes <max-connections> + parallel_max_servers + 40 query_rewrite_enabled false recyclebin, customer component bc-db-ora oracle priority recommendations / additional info category installation information validity, install sap bundle patch sap_102044_201005 1336972 bw oracle rsrv parameter compatible 828268 oracle database 10g, 1171650 automated oracle db parameter check 914177 file system reiserfs oracle parameter filesystemio_options 1233458 error, set parallel_execution_message_size 16384 parallel_max_servers #db-cpu-cores 10 parallel_threads_per_cpu 1 pga_aggregate_target oltp, higher core_dump_dest <sapdata_home>/saptrace/background db_block_size 8192 db_cache_size size depends, hp-ux 1171650 automated oracle db parameter check 1165319 optimizer merge fix, advanced configuration 914177 file system reiserfs oracle parameter filesystemio_options 900345 backward release, ccms - ora-check - database health check alert 1137346 oracle 10, 0 parameter recommendation ------------------------------- ------------------------------------ background_dump_dest <sapdata_home>/saptrace/background commit_write
Notes associées :
| 1622837 | Secure connection of AS ABAP to Oracle via SSFS |
| 1527468 | Oracle 10.2.0.5 underscore spare parameter |
| 1525673 | Optimizer merge fix for Oracle 10.2.0.5 |
| 1487754 | Add. info.: Upgrade to SAP NW 7.3 ORACLE |
| 1476753 | NetWeaver BPM: Performance issues on Oracle Database |
| 1475345 | Oracle 10.2.0.4 underscore spare parameter |
| 1475173 | Contention with auto-tuned undo retention |
| 1472386 | ORA-04031 out of memory error in BW systems |
| 1468914 | ORA-55567 after install SAP Bundle Patch SAP_102044_201005 |
| 1431752 | Oracle 10.2.0: Patches/Patch Collections for 10.2.0.5 |
| 1342593 | Account search: Performance issue with name and address |
| 1336972 | BW Oracle RSRV parameter COMPATIBLE |
| 1325833 | Error in Console: The MDM repository is invalid |
| 1289199 | Information about Oracle parameters |
| 1284478 | Poor performance when using Btree bitmap plans |
| 1284406 | MISSING_STATISTICS warning after new installation |
| 1273790 | kks* merge fix for Oracle 10.2.0.4 |
| 1238487 | Update of threshold values of database system check |
| 1233458 | Error during startup: ORA-00940: invalid ALTER command |
| 1227227 | SQL statement runs endlessly or times out (kkompr) |
| 1225732 | Oracle 10.2 ccNUMA optimization on HP-UX |
| 1171650 | Automated Oracle DB parameter check |
| 1165319 | Optimizer merge fix for Oracle 10.2.0.4 |
| 1146843 | |
| 1137346 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4 |
| 1122246 | Central note SAP NetWeaver 7.0 Rapid Installer for SPS 14 |
| 1119194 | 10.2.0.2: Incorrect result set with Bloom filters |
| 1117785 | RW: Wrong data / bad performance with ORACLE 10g |
| 1085874 | Performance in International Financial Reporting Standards |
| 1085873 | Performance in BaselII Capital Accord |
| 1077887 | SAP on HP-UX:mount & filesystem options for best performance |
| 1075118 | SAP on HP-UX: FAQ |
| 1044174 | Recommendation for CC 5.x running on Oracle 10G Database |
| 1040300 | Wrong values with Star Transformation Hint 9.2.0.8 /10.2.0.2 |
| 1037651 | Oracle 10.2.0.2: Long parsing times for complex joins |
| 1031682 | ORA-04031 due to shared pool component "mvobj part des" |
| 1013912 | FAQ: Oracle BW performance |
| 1013476 | ORA-600 kcbzpbuf_1 during array insert causes corruption |
| 1009332 | Central note SAP NetWeaver 2004s Rapid Installer for SPS 11 |
| 999524 | Oracle 10.2 platform support for Async IO |
| 999126 | Performance improvement for star queries |
| 997889 | Error ORA-04031 due to "_fix_control" |
| 980805 | ORA-600 kdtigetrow-2 w/ array insert leads to corruptions |
| 977319 | Incorrect values in Oracle 10.2 (II) |
| 964858 | Incorrect vals w/ STAR_TRANSFORMATION_ENABLED in Oracle 10.2 |
| 960790 | Upgrade to SAP NetWeaver 7.1 AS ABAP/AS Java ORACLE |
| 960633 | Merge Join Cartesian in complex join |
| 949847 | |
| 948294 | AIX JFS2: mount options to use with Oracle 10g / 11g |
| 934808 | SAP Enterprise Portal on Oracle: Advanced Configuration |
| 914177 | File system reiserfs Oracle parameter filesystemio_options |
| 900345 | Backward Release of ORACLE 10.2 - Upgrade Information |
| 899070 | ORA-01406 reported on SELECT against SAP Tables (eg.TRDIR) |
| 885167 | Add. info.: Upgrade to SAP NetWeaver 7.0 Java ORACLE |
| 848708 | Oracle Database Configuration for NWDI server |
| 819830 | Oracle Database 10g: Additional Information on upgrade:UNIX |
| 819655 | Add. info.: Upgrade to SAP NW 2004s ABAP ORACLE |
| 789011 | FAQ: Oracle memory areas |
| 755342 | Incorrect execution plans with bind variable peeking |
| 720886 | Oracle Database 10g: Integration into the SAP environment |
| 690241 | The Shared SQL Area in the Shared Pool and large SQL Stmnts |
| 632556 | Oracle 9.2.0.* database parameterization for BW |
| 619876 | Oracle9i: Automatic PGA Memory Management |
| 619188 | FAQ: Oracle wait events |
| 618868 | FAQ: Oracle performance |
| 617416 | Oracle9i: Dynamic SGA |
| 601157 | Oracle9i: Server Parameter File |
| 600141 | Oracle9i: Automatic UNDO Management |
| 596423 | Events and SPFILE |
| 596420 | System standstill during deadlock (ORA-60) |
| 592393 | FAQ: Oracle |
| 527481 | tRFC or qRFC calls are not processed |
| 378509 | Oracle DB parameter setting for APO |
| 192055 | BRCONNECT warnings despite correct parameter values |
| 180605 | Oracle database parameter settings for BW |
| 176754 | Problems with CBO and RBO |
| 132551 | Overflow log sequence numbers on NT |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |
| 79341 | Checkpoint not complete |
| 1135916 | Line items: Help for analysis for long runtime |
| 828268 | Oracle Database 10g: New functions |