Solution : https://service.sap.com/sap/support/notes/1165319 (SAP Service marketplace login required)
Summary :
Due to issues identified with Oracle Optimizer errors, SAP delivers an essential Cost-Based Optimizer (CBO) merge fix in its latest bundle patch. These fixes address multiple bugs across various versions, ensuring improvements in query optimizer performance, hash join methods, execution path stability, and incorrect results management. Key enhancements include adjustments to invalid cursor behaviors, ORA-600 error mitigations, fixes for poor query performance particularly with incorrect cardinality estimations, and stabilization of database interactions under specific parameters such as cursor_sharing settings. These measures are crucial for maintaining optimal performance and reliability in Oracle environments integrated with SAP systems.
Key words :
left outer join query performs badly becaus nestedloops join 8323407, sysdba start $oracle_home/rdbms/admin/dbmsstat, sysdba start $oracle_home/rdbms/admin/prvtstas, plb start $oracle_home/rdbms/admin/prvtstat, sysdba start $oracle_home/rdbms/admin/utlrp, sql start $oracle_home/rdbms/admin/prvtstas, star transformed sql statement causing ora-7445 [kkfdmrk, 64-stream tpch throughput run shows ora-600 [733], ora-00600 internal error code [kdisle nrows], parallel servers die unexpectedly resulting
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 |