Solution : https://service.sap.com/sap/support/notes/122718 (SAP Service marketplace login required)
Summary :
This SAP Note addresses issues related to poor performance and deviating statistics due to suboptimal handling of statistics with BRCONNECT in environments using Oracle 9i or lower. It provides guidance on when and how to create or avoid the creation of statistics for specific tables, leveraging either the Cost Based Optimizer (CBO) or the Rule Based Optimizer (RBO). Exception rules in the DBSTATC control table, along with script adjustments provided in dbstatc.sql or dbstatc10.sql, are outlined for managing statistics effectively while avoiding performance degradation. Additionally, this note details settings for temporary statistics and histograms to improve table evaluation.
Key words :
mkpf ppc_head rsdd_tmpnm_adm bdcp, sap-standard exception rules, cost based optimizer, rule based optimizer, widely varying contents, coix_data40 buffer synchronization, ddntf short dumps, sap application monitor, ddxtt table conversion, tataf table logging
Related Notes :
| 1374807 | Freezing single kinds of statistics |
| 1020260 | Delivery of Oracle statistics (Oracle 10g, 11g) |
| 869006 | Composite SAP note: ORA-04031 |
| 797629 | FAQ: Oracle histograms |
| 766349 | FAQ: Oracle SQL optimization |
| 756335 | Statistics in tables w/ heavily fluctuating volumes of data |
| 742950 | Performance affected on Oracle DB with Supplement 11 |
| 618868 | FAQ: Oracle performance |
| 588668 | FAQ: Database statistics |
| 505246 | Several ora-600 [12333] and ora-4031 errors |
| 403704 | BRCONNECT - Enhanced function for Oracle DBA |
| 131372 | CBO: Tuning of expensive SQL statements |
| 106047 | DB21: Customizing the DBSTATC |