Solution : https://service.sap.com/sap/support/notes/892296 (SAP Service marketplace login required)
Summary :
SAP Note Update: In BRCONNECT 7.00, SAP introduces significant enhancements to optimizer statistics collection, specifically incorporating Oracle 10g DBMS_STATS package capabilities. Key enhancements include the addition of auto-sampling, histograms, index validation, and expanded force options offering finer control over statistical methods and bucket sizes. These improvements facilitate tailored, automated statistical updates, improving database performance. Adhering to recommended use guidelines and understanding configurations are essential for effective implementation. For detailed parameter options, refer to the enriched syntax structure and consider consulting respective Oracle documentation for comprehensive understanding.
Key words :
sql> connect sap<sid>/<pwd>sql> insert, auto-sample size + histograms + validation2, analysis method - dbms_stats auto-sampling----------------------------------------------------------------, bucket sizes - dbms_stats size option-----------------------------------------------------------------, 'd' - default oracle degreeno -, auto-sample size + validation, statistical change threshold values, lower statistical change threshold, - reduce column statistics update, oracle 10g dbms_stats package
Related Notes :
| 1060305 | Corrections in BR*Tools Version 7.10 |
| 849483 | Corrections for BR*Tools Version 7.00 |
| 618868 | FAQ: Oracle performance |
| 588668 | FAQ: Database statistics |
| 424239 | New BRCONNECT parameter: stats_dbms_stats |
| 408532 | Using the DBMS_STATS package for collecting statistics |