Solution : https://service.sap.com/sap/support/notes/424239 (SAP Service marketplace login required)
Summary :
BRCONNECT 6.10, preceding patch level 9, required manual setting of parallelism per table via "ALTER TABLE" for DBMS_STATS package usage, which was cumbersome. The new parameter 'stats_dbms_stats' allows explicit control over statistics updates on Oracle databases. Settings include specifying overall or individual table statistic updates with options for row or block sampling and parallelism degree. Examples provided specify different configurations. Proper application of these settings can simplify handling and optimize performance in environments running Oracle. Post-update caution advises recompilation of statistics using BRCONNECT to ensure consistency.
Key words :
cost-based optimizer reason, - activates block sampling <degree> - degree, sap profile parameter stats_dbms_stats, statistic collectionthe optional, set init<sid>, 1this parameter activates, parallel query option, sap parameter stats_dbms_stats, standard sampling type, - activates row sampling
Related Notes :
| 1013912 | FAQ: Oracle BW performance |
| 892296 | Enhancements in update statistics in BRCONNECT 7.00/7.10 |
| 806554 | FAQ: I/O-intensive database operations |
| 635564 | |
| 588668 | FAQ: Database statistics |
| 525235 | |
| 428212 | Using BRCONNECT to update InfoCube statistics |
| 408532 | Using the DBMS_STATS package for collecting statistics |
| 403706 | Corrections in BR*Tools Version 6.10 |
| 403704 | BRCONNECT - Enhanced function for Oracle DBA |