Solution : https://service.sap.com/sap/support/notes/830576 (SAP Service marketplace login required)
Summary :
Key words :
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
Related Notes :
| 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 |