Solution : https://service.sap.com/sap/support/notes/215917 (SAP Service marketplace login required)
Key words :
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
Related Notes :
| 184513 | CBO: Parallel generation of optimizer statistics |
| 184133 | Additions Oracle migr./upgrade to 8.0.6: UNIX |
| 170989 | Poor performance under Oracle 8044, 805*, 8.0.6 |
| 160063 | Oracle DB parameter setting for R/3 3.x and Oracle8/Oracle9 |
| 143163 | Additions Oracle migr./ upgrade to 8.0.5: UNIX |
| 135048 | Long runtimes statements w/ ROWNUM <= condition |
| 132861 | CBO: Statistics creation with SAPDBA or BRCONNECT |
| 131372 | CBO: Tuning of expensive SQL statements |
| 127715 | CBO: Optimum parameters for performance |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |
| 102475 | CBO: Release information |
| 23875 | Released operating systems for R/3 3.0x/3.1x ORACLE |