SAP Note 132861 - CBO: Statistics creation with SAPDBA or BRCONNECT

Composant : Database Administration with Oracle - Oracle

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

Mots Clés :
calculate correct access paths, sapdba command line functions, cost-based optimizer, cost-cased optimizer, operating system level, aforementioned log files, sapdba -analyze dbstatco, symptom system performance, sapdba -checkopt psap%, sapdba -checkopt

Notes associées :

766349FAQ: Oracle SQL optimization
618868FAQ: Oracle performance
588668FAQ: Database statistics
403704BRCONNECT - Enhanced function for Oracle DBA
303140Techn.object: performance problem f.structure lists
215917Easy change from Rule to Cost-Based Optimizer
184513CBO: Parallel generation of optimizer statistics
131372CBO: Tuning of expensive SQL statements
118556SAPDBA: New ALIAS (DBAORA) and NEWS in the SAPNET
109034Collective note: SAPDBA - performance/CBO
96296CC-ERROR: Database problem in client copy
93256CBO: Changes for installation of 4.0
93098CBO: Changes in upgrade to 4.0