SAP Note 127715 - CBO: Optimum parameters for performance

Composant : Oracle -

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

Mots Clés :
additional key words cbo, oracle supportyou find information, oracle cost-based optimizer, cost based optimizer, full table scan, symptom bad performance, massive performance problems, reason parameter settings, good system performance, newest patchsetfor problems

Notes associées :

544881Composite SAP note: Time-driven jobs do not run
375685Oracle 8.0: Problems due to optimizer_features_enable> 8.0.0
370601Composite SAP note: APO 3.0 and 3.1 performance
316013Message CX701 when creating a sales order
215917Easy change from Rule to Cost-Based Optimizer
184134Current patch set for Oracle 8.0.6
170989Poor performance under Oracle 8044, 805*, 8.0.6
164238Performance matchcode search ac.to p. order number
135048Long runtimes statements w/ ROWNUM <= condition
131372CBO: Tuning of expensive SQL statements
128293Collective note: IS-U & IS-T performance problems
127395Current patch set for Oracle Rel. 8.0.5
124361Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x)
114716Performance problems Oracle 8.0.4/all entries
109034Collective note: SAPDBA - performance/CBO
103747Performance: Parameter recommendations as of Release 4.0
99311Current patch set 8.0.4.X
96296CC-ERROR: Database problem in client copy