Solution : https://service.sap.com/sap/support/notes/960633 (SAP Service marketplace login required)
Key words :
terms merge join cartesian mjc oracle change run long runtime reason, 'merge join cartesian', merge join cartesian, change run, oracle execution plan, oracle release 10g, symptom statements occur, long runtimes, oracle release 9, oracle bug 5262465
Related Notes :
| 830576 | Parameter recommendations for Oracle 10g |
| 632556 | Oracle 9.2.0.* database parameterization for BW |
| 596423 | Events and SPFILE |
| 176754 | Problems with CBO and RBO |
| 124361 | Oracle parameterization (R/3 >= 4.x, Oracle 8.x/9.x) |