Solution : https://service.sap.com/sap/support/notes/632556 (SAP Service marketplace login required)
Key words :
log_checkpoint_interval 0 log_archive_start true log_buffer 1048576 log_checkpoint_timeout 0 log_checkpoints_to_alert true max_dump_file_size 20000 open_cursors 800 optimizer_features_enable 9, 0 optimizer_mode choose parallel_execution_message_size 16384 parallel_max_servers #db-cpu-cores 10 optimizer_max_permutations 2000 parallel_threads_per_cpu 1 pga_aggregate_target 40%, timed_statistics true transaction_auditing false workarea_size_policy auto _b_tree_bitmap_plans false _eliminate_common_subexpr false, shared_pool_size sessions >= processes star_transformation_enabled true statistics_level basic, numerous sap/oracle customer systems, consecutive rows filesystemio_options setall, recommendation ------------------------------- ------------------------------------- compatible current release, db_block_size 8192 db_cache_size size depends, hash_join_enabled true java_pool_size 0, _optim_peek_user_binds false _pga_max_size
Related Notes :
| 1109753 | Table prefetching produces incorrect result sets |
| 1013912 | FAQ: Oracle BW performance |
| 960633 | Merge Join Cartesian in complex join |
| 936441 | Oracle settings for R3load based system copy |
| 888626 | Redo log layout for high-end systems |
| 834343 | Oracle 9.2 Platform Support for Async IO |
| 830576 | Parameter recommendations for Oracle 10g |
| 789011 | FAQ: Oracle memory areas |
| 755342 | Incorrect execution plans with bind variable peeking |
| 717496 | Wrong results with STAR_TRANSFORMATION_ENABLED=TRUE |
| 667236 | Obsolete parameters in Oracle 9.2.0.* |
| 635974 | Error when upgrading to Oracle 9.2.X - Windows |
| 632427 | Oracle 8.1.7* database parameterization for BW |
| 609430 | Error messages due to obsolete parameters |
| 594513 | Oracle 9.2.0: Result not sorted in spite of ORDER BY |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 378509 | Oracle DB parameter setting for APO |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |