SAP Note 184513 - CBO: Parallel generation of optimizer statistics

Composant : Database Administration with Oracle -

Solution : https://service.sap.com/sap/support/notes/184513 (Connexion à SAP Service Marketplace requise)

Mots Clés :
sapdba -anaylze dbstatco und         sapdba -checkopt psap%, additional arguments correspondsthe call option sapdba -statistics, analyze table compute statistics method eh/ch, general informationthe complete call option, store objects withstatitics requirements temporarily, analyze table estimate/compute statistics, method estimate statistics sample 1 percent, analyze table estimate statistics method, additional key words cbo, loggingthe respective operation log

Notes associées :

489690CC INFO: Copying large production clients
408532Using the DBMS_STATS package for collecting statistics
408527Checking the statistics using DBA_TAB_MODIFICATIONS
403713BRCONNECT: Parallel updating of statistics
403706Corrections in BR*Tools Version 6.10
403704BRCONNECT - Enhanced function for Oracle DBA
301608CBO: incor. method for creating initial stat.
215917Easy change from Rule to Cost-Based Optimizer
182758CBO: Create histograms / new internal rules
132861CBO: Statistics creation with SAPDBA or BRCONNECT