Solution : https://service.sap.com/sap/support/notes/992261 (SAP Service marketplace login required)
Key words :
query runs 5 times slower 3521347 appsst10g 10g plan worse, star_transformation_enabled = temp_disable 5084239 fact hint forces suboptimal plan, optimizer_index_cost_adj = 100 4541524 wrong result temp table transformation workaround, bugs 4541524 4483286 5140931 4372359 4541524 wrong result temp table transformation 4483286 optimizer_index_cost_adj, direct binds 4372359 wrong results star transfo, ziplinux ia_64 /oracle/oracle 64-bit/oracle 9, aix 5l /oracle/oracle 64-bit/oracle 9, ziplinux x86-64 /oracle/oracle 64-bit/oracle 9, ziplinux 32-bit /oracle/oracle 64-bit/oracle 9, ziphp tru64 /oracle/oracle 64-bit/oracle 9
Related Notes :
| 1049390 | Poor performance for multiple OR conditions and IN lists |
| 938986 | Oracle Database 9.2: Patches for 9.2.0 |
| 658322 | Composite SAP Note: Incorrect resulting set with Oracle |
| 539921 | Current patch set for Oracle 9.2.0 |
| 354080 | Note collection for Oracle performance problems |
| 176754 | Problems with CBO and RBO |