Solution : https://service.sap.com/sap/support/notes/1165319 (SAP Service marketplace login required)
Key words :
Oracle, CBO, optimizer merge fix, 10.2.0.4, STAR TRANSFORMATION, wrong values, ORA-00600, ORA-07445, _fix_control, performance
Related Notes :
| 1284406 | MISSING_STATISTICS warning after new installation |
| 1257511 | Oracle 10.2.0.4 - Wrong Results Unless Ansi Outer Join Used |
| 1248584 | Oracle 10.2.0.4 - Wrong results possible from predicate push |
| 1232043 | SELECT on V$DATAFILE is slow with Oracle 10.2.0.x |
| 1227227 | SQL statement runs endlessly or times out (kkompr) |
| 1137346 | Oracle 10.2.0: Patches/patch collections for Oracle 10.2.0.4 |
| 830576 | Parameter recommendations for Oracle 10g |