SAP Note 408532 - Using the DBMS_STATS package for collecting statistics

Component : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/408532 (SAP Service marketplace login required)

Summary :
SAP Note details how to utilize Oracle’s DBMS_STATS package instead of the ANALYZE command for collecting statistics in Oracle databases integral to SAP environments. Leveraging DBMS_STATS from Oracle 8.1 onwards can reduce BRCONNECT runtime, particularly when deploying internal parallel processing for large tables over several hundred GB. Users should modify the init.sap profile by setting the stats_dbms_stats parameter for activating this feature. Crucial for efficiency, it’s recommended to recompile statistics post-activation using BRCONNECT. Oracle 10g employs DBMS_STATS as standard, negating any need for special settings beyond specific scenarios.

Key words :
internal parallel setting feature, prerequisites recommendations/additional informationprerequisite, sap profile parameter stats_dbms_stats, medium-sized packages, set init<sid>, sap oracle database, dbms_stats supplied package, sap profile, stats_dbms_stats parameter, 2 solution set

Related Notes :

1013912FAQ: Oracle BW performance
892296Enhancements in update statistics in BRCONNECT 7.00/7.10
635564
588668FAQ: Database statistics
439783BR986W Index ... is unbalanced - please rebuild the index
428212Using BRCONNECT to update InfoCube statistics
424239New BRCONNECT parameter: stats_dbms_stats
403713BRCONNECT: Parallel updating of statistics
403706Corrections in BR*Tools Version 6.10
403704BRCONNECT - Enhanced function for Oracle DBA
184513CBO: Parallel generation of optimizer statistics
105047Support for Oracle functions in the SAP environment