Solution : https://service.sap.com/sap/support/notes/403713 (SAP Service marketplace login required)
Summary :
The BRCONNECT Version 6.10 initially provided in SAP kernel 4.6D SR2 only performed serial updates for optimizer statistics, leading to lengthy runtimes for large databases. A solution was introduced in the first patch of BRCONNECT 6.10, enabling parallel processing via the “-p” option or the “stats_parallel_degree” parameter, which allows users to set the number of parallel threads. However, benefits from parallel processing are less significant for smaller databases due to thread synchronization. Additionally, parallel processing isn’t supported on Reliant platforms. Users can refer to SAP Notes for detailed guidance and patches.
Key words :
additional key words update statistics, oracle dce thread implementation, 6d service release 2, unnecessarily long runtimes, stats_parallel_degree init<sid>, 4stats_parallel_degree = 4the standard, thread synchronization required, medium-sized databases, sap parameters stats_parallel_degree, cost-based optimizer
Related Notes :
| 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 |
| 184513 | CBO: Parallel generation of optimizer statistics |
| 96296 | CC-ERROR: Database problem in client copy |