Solution : https://service.sap.com/sap/support/notes/634263 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues observed in ABAP programs utilizing "FOR ALL ENTRIES" where inappropriate indexes or full table scans lead to high runtimes and costs. Adjustments to the 'rsdb/prefer_in_itab_opt' parameter, which influences how "FOR ALL ENTRIES" is executed, have been recommended. To enhance performance and reduce system strain, especially on memory and CPU resources, the optimal value for 'rsdb/max_in_blocking_factor' should be set at 5. Through transaction ST05, users can test the impact of these adjustments on system behavior. This note emphasizes the importance of consistent parameter settings across all instances for reliability and optimal function.
Key words :
transaction sm50 -> process -> trace -> display file, db server increases considerably due, rsdb/max_in_blocking_factor = 5 rsdb/min_in_blocking_factor = 5when, terms rsdb/max_blocking_factor rsdb, call transaction st05, work process log, parameter rsdb/max_in_blocking_factor, full table scan, incorrect access paths, work processes free
Related Notes :
| 1500503 | BI quantity conversion: Access optimization |
| 881083 | Blocking factors on Oracle-based systems |
| 712624 | High CPU consumption by Oracle |
| 706132 | Composite SAP Note: Problems with Oracle 9i |
| 682726 | Access to LTAP with IN list with an incorrect index |
| 653645 | Composite SAP Note performance |
| 620361 | Data loading performance/Admin. data target, many requests |
| 601612 | P11: Manage: Slow formatting due to large Oracle IN list |
| 592366 | BCT-IM: Performance optimization when reading from PSA |
| 568908 | Performance of CRM Initial Download on Test Systems |
| 567745 | Composite note BW 3.x performance: DB-specific setting |
| 556764 | Upgrade hangs in phase ACT_<REL> |
| 550226 | CC-ADMIN: Copying the Customizing takes a long time |
| 458077 | For all entries: Performance problems in APO Demand Planning |
| 176754 | Problems with CBO and RBO |
| 48230 | Parameters for the SELECT ... FOR ALL ENTRIES statement |