SAP Note 588668 - FAQ: Database statistics

Component : Oracle - Database Administration with Oracle

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

Key words :

Related Notes :

1576108Oracle 11g or higher: Extended CBO statistics
1232776Long runtimes for accesses to D010INC or D010TAB
1095171Exporting index statistics via DBMS_STATS fails
1057511Collecting statistis - An alternative approach
1013912FAQ: Oracle BW performance
927295FAQ: Oracle system statistics
892296Enhancements in update statistics in BRCONNECT 7.00/7.10
848708Oracle Database Configuration for NWDI server
838725Oracle dictionary statistics and system statistics
832343FAQ: Clustering factor
826814SMSY: Expanding 'Systems' takes a long time
825653Oracle: Common misconceptions
821687FAQ: Space utilization and fragmentation in Oracle
806554FAQ: I/O-intensive database operations
797629FAQ: Oracle histograms
766349FAQ: Oracle SQL optimization
750631Approximations for cost calculation of the CBO
744483Changes in collection of statistics in BRCONNECT 6.40
724545Adjusting the CBO statistics manually using DBMS_STATS
690702Histograms cause long runtimes on Oracle 9
657536Transports and DB Statistic Calculation
651812FAQ: BR*TOOLS and SAPDBA
628590Activating table monitoring using "-f monit" option
618868FAQ: Oracle performance
590370Too many uncompressed request (f table partitions)
564161Transport profile parameter 'dropstatistics'
558746Better Oracle Data Dictionary BW Performance
555030Deactivating BW-initiated DB statistics
524341Updating the statistics for individual partitions
448380Information: Oracle Package DBMS_STATS
428212Using BRCONNECT to update InfoCube statistics
424239New BRCONNECT parameter: stats_dbms_stats
408532Using the DBMS_STATS package for collecting statistics
408527Checking the statistics using DBA_TAB_MODIFICATIONS
403713BRCONNECT: Parallel updating of statistics
403704BRCONNECT - Enhanced function for Oracle DBA
365480CBO: Field filled with leading "0" aligned to left
211105DB21: You cannot create transport requests
132861CBO: Statistics creation with SAPDBA or BRCONNECT
129252Oracle DB Statistics for BW Tables
122718CBO: Tables with special treatment
106047DB21: Customizing the DBSTATC
105047Support for Oracle functions in the SAP environment