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