Solution : https://service.sap.com/sap/support/notes/180605 (SAP Service marketplace login required)
Key words :
hash_area_size sort_area_size 2hash_join_enabled truehash_multiblock_io_count 32log_archive_start truelog_buffer 1048576log_checkpoint_interval 3000000000log_checkpoint_timeout 0´log_checkpoints_to_alert truelog_simultaneous_copies # cpus 2max_dump_file_size 20000open_cursors 800optimizer_index_cost_adj < delete, note 128221hash_area_size sort_area_size 2hash_join_enabled truehash_multiblock_io_count 32log_archive_start truelog_buffer 1048576log_checkpoint_interval 3000000000log_checkpoint_timeout 0log_checkpoints_to_alert truelog_simultaneous_copies # cpus 2max_dump_file_size 20000, profile>optimizer_mode chooseoptimizer_percent_parallel 100parallel_broadcast_enabled trueparallel_execution_message_size 16384parallel_max_servers # cpus 2processes >, db_block_checkpoint_batch >= 8db_block_lru_latches # cpus 2db_block_size 8192db_file_multiblock_read_count 32distributed_transactions 0, profile >parallel_max_servers # cpus 8parallel_threads_per_cpu 1processes >, cpus 2db_block_size 8192db_file_multiblock_read_count 32distributed_transactions 0, sort_direct_writes truesort_write_buffers 4sort_write_buffer_size 262144star_transformation_enabled true, ensure error-free database operation, numerous sap/oracle customer systems, --------------------------- ------------------------------always_anti_join hashbitmap_merge_area_size 33554432b_tree_bitmap_plans < delete
Related Notes :
| 1238487 | Update of threshold values of database system check |
| 830576 | Parameter recommendations for Oracle 10g |
| 632427 | Oracle 8.1.7* database parameterization for BW |
| 598470 | Error due to "compatible" parameter |
| 592393 | FAQ: Oracle |
| 558746 | Better Oracle Data Dictionary BW Performance |
| 540021 | Add. information on migrating/updating to Oracle 9.2.0: UNIX |
| 534729 | Oracle errors due to network problems |
| 483856 | Description of the alerts for Oracle database monitoring |
| 458077 | For all entries: Performance problems in APO Demand Planning |
| 415900 | General recommendation for Oracle patch sets |
| 387056 | Additional bugfixes for 8.1.7 |
| 380523 | Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE |
| 378509 | Oracle DB parameter setting for APO |
| 376905 | Long parsing times and Library Cache Locks |
| 375685 | Oracle 8.0: Problems due to optimizer_features_enable> 8.0.0 |
| 370601 | Composite SAP note: APO 3.0 and 3.1 performance |
| 359835 | Design of the temporary tablespace in the BW System |
| 358921 | Oracle database parameterization for SEM |
| 358917 | Oracle DB parameterization for CRM and BBP |
| 357016 | Incorrect results with PARALLEL hint |
| 336402 | Massive performance problems with 8.1.6 |
| 335230 | ORA-4030 with NT and Business Information Warehouse |
| 332696 | ORA-00600 [2865], star_transformation_enabled |
| 332105 | ORA-3113, ORA-7445 with Oracle 8.1 |
| 320540 | Oracle param. no longer supported as of Vers. 8.1 |
| 217478 | CBO returns incorrect values in BW environment |
| 192658 | Setting parameters for BW systems |
| 192055 | BRCONNECT warnings despite correct parameter values |
| 184905 | Collective note Performance BW 2.0 |
| 184134 | Current patch set for Oracle 8.0.6 |
| 179198 | Collectv Transprt of First Correctns for APO 2.0A |
| 164925 | Storage parameter of tablespace PSAPTEMP |
| 156319 | Collective note performance BW 1.2B |
| 153909 | Demand Planning: Performance - Consulting |
| 132503 | Update of threshold values for database system chck |
| 130253 | General tips on uploading transaction data to BW |
| 128221 | Increased memory consumption with Oracle >8.0.X |
| 127395 | Current patch set for Oracle Rel. 8.0.5 |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |