SAP Note 180605 - Oracle database parameter settings for BW

Composant : BW Database Platforms - Backoffice Service Delivery

Solution : https://service.sap.com/sap/support/notes/180605 (Connexion à SAP Service Marketplace requise)

Mots Clés :
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

Notes associées :

1238487Update of threshold values of database system check
830576Parameter recommendations for Oracle 10g
632427Oracle 8.1.7* database parameterization for BW
598470Error due to "compatible" parameter
592393FAQ: Oracle
558746Better Oracle Data Dictionary BW Performance
540021Add. information on migrating/updating to Oracle 9.2.0: UNIX
534729Oracle errors due to network problems
483856Description of the alerts for Oracle database monitoring
458077For all entries: Performance problems in APO Demand Planning
415900General recommendation for Oracle patch sets
387056Additional bugfixes for 8.1.7
380523Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE
378509Oracle DB parameter setting for APO
376905Long parsing times and Library Cache Locks
375685Oracle 8.0: Problems due to optimizer_features_enable> 8.0.0
370601Composite SAP note: APO 3.0 and 3.1 performance
359835Design of the temporary tablespace in the BW System
358921Oracle database parameterization for SEM
358917Oracle DB parameterization for CRM and BBP
357016Incorrect results with PARALLEL hint
336402Massive performance problems with 8.1.6
335230ORA-4030 with NT and Business Information Warehouse
332696ORA-00600 [2865], star_transformation_enabled
332105ORA-3113, ORA-7445 with Oracle 8.1
320540Oracle param. no longer supported as of Vers. 8.1
217478CBO returns incorrect values in BW environment
192658Setting parameters for BW systems
192055BRCONNECT warnings despite correct parameter values
184905Collective note Performance BW 2.0
184134Current patch set for Oracle 8.0.6
179198Collectv Transprt of First Correctns for APO 2.0A
164925Storage parameter of tablespace PSAPTEMP
156319Collective note performance BW 1.2B
153909Demand Planning: Performance - Consulting
132503Update of threshold values for database system chck
130253General tips on uploading transaction data to BW
128221Increased memory consumption with Oracle >8.0.X
127395Current patch set for Oracle Rel. 8.0.5
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)