Solution : https://service.sap.com/sap/support/notes/124361 (SAP Service marketplace login required)
Key words :
sort_area_retained_size 0 sort_area_size 2097152 timed_statistics true transaction_auditing false _b_tree_bitmap_plans false _eliminate_common_subexpr false, processes #sap work processes 2 + 20 remote_os_authent true replication_dependency_tracking false, achieve error-free database operation, disk areas db_block_buffers size depends, log_archive_start true log_buffer 1048576 log_checkpoint_interval 3000000000, recommendation ------------------------------- ------------------------------------- compatible current release, medium-term expected number, 10 cpus max_dump_file_size 20000 max_rollback_segments >= number, sap/oracle customer systems, note 358921 customer relationsship management
Related Notes :
| 1429324 | Improvement of the runtime behavior of RC1PHDEL |
| 1238487 | Update of threshold values of database system check |
| 1109753 | Table prefetching produces incorrect result sets |
| 1044174 | Recommendation for CC 5.x running on Oracle 10G Database |
| 960633 | Merge Join Cartesian in complex join |
| 936441 | Oracle settings for R3load based system copy |
| 857081 | Unicode conversion: downtime estimate |
| 848708 | Oracle Database Configuration for NWDI server |
| 834343 | Oracle 9.2 Platform Support for Async IO |
| 830576 | Parameter recommendations for Oracle 10g |
| 823906 | Oracle 9 database parameters tuning - EP in NW |
| 806554 | FAQ: I/O-intensive database operations |
| 778700 | Bank Analyzer: Database parameter Tool-BW |
| 755342 | Incorrect execution plans with bind variable peeking |
| 635974 | Error when upgrading to Oracle 9.2.X - Windows |
| 632556 | Oracle 9.2.0.* database parameterization for BW |
| 626172 | Performance problems with Outer Join queries in Oracle 9.2 |
| 621349 | |
| 618868 | FAQ: Oracle performance |
| 598470 | Error due to "compatible" parameter |
| 592393 | FAQ: Oracle |
| 544881 | Composite SAP note: Time-driven jobs do not run |
| 540021 | Add. information on migrating/updating to Oracle 9.2.0: UNIX |
| 534729 | Oracle errors due to network problems |
| 505246 | Several ora-600 [12333] and ora-4031 errors |
| 485755 | ORA-03232: unable to allocate an extent of blocks |
| 483856 | Description of the alerts for Oracle database monitoring |
| 458077 | For all entries: Performance problems in APO Demand Planning |
| 435290 | Description of BRCONNECT 6.10 DB check conditions |
| 415900 | General recommendation for Oracle patch sets |
| 376905 | Long parsing times and Library Cache Locks |
| 375685 | Oracle 8.0: Problems due to optimizer_features_enable> 8.0.0 |
| 362068 | Supplement to Oracle migration/upgrade to 8.1.7: UNIX |
| 358921 | Oracle database parameterization for SEM |
| 358917 | Oracle DB parameterization for CRM and BBP |
| 334006 | ABAP short dump SQL 1652 GET_03M_X_X_X |
| 320540 | Oracle param. no longer supported as of Vers. 8.1 |
| 216888 | Additions: Oracle migr./upgrade to 8.1.6: UNIX |
| 215917 | Easy change from Rule to Cost-Based Optimizer |
| 192055 | BRCONNECT warnings despite correct parameter values |
| 184134 | Current patch set for Oracle 8.0.6 |
| 180605 | Oracle database parameter settings for BW |
| 170989 | Poor performance under Oracle 8044, 805*, 8.0.6 |
| 166833 | IS-U/CCS: Notes on inst. & prod. system operation |
| 165247 | Notes on creating rollback segments |
| 161552 | Generation: SQL error 1652 accessing table DD03M |
| 160063 | Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9 |
| 132503 | Update of threshold values for database system chck |
| 131372 | CBO: Tuning of expensive SQL statements |
| 128648 | Incorrect path used due to rounding errors |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 127715 | CBO: Optimum parameters for performance |
| 124763 | DDF, KDF: poor performance with Oracle |
| 114716 | Performance problems Oracle 8.0.4/all entries |