SAP Note 215917 - Easy change from Rule to Cost-Based Optimizer

Composant : Backoffice Service Delivery -

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

Mots Clés :
calling        sapdba -analyze dbstatcothis call analyzes, additional key words functional upgrade, oracle cost-based optimizer, cost-based optimizer prior, oracle rule-based optimizer, cost-based optimizer statistics, oracle release version 8 long, cost-based optimizer, rule-based optimizer, low system load

Notes associées :

184513CBO: Parallel generation of optimizer statistics
184133Additions Oracle migr./upgrade to 8.0.6: UNIX
170989Poor performance under Oracle 8044, 805*, 8.0.6
160063Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9
143163Additions Oracle migr./ upgrade to 8.0.5: UNIX
135048Long runtimes statements w/ ROWNUM <= condition
132861CBO: Statistics creation with SAPDBA or BRCONNECT
131372CBO: Tuning of expensive SQL statements
127715CBO: Optimum parameters for performance
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
102475CBO: Release information
23875Released operating systems for R/3 3.0x/3.1x ORACLE