Solution : https://service.sap.com/sap/support/notes/1525681 (SAP Service marketplace login required)
Summary :
This SAP Note delivers a resolution for multiple Oracle optimizer errors by including a cost-based optimizer (CBO) merge fix in the SAP bundle patches for UNIX and Grid Infrastructure. The update addresses specific issues across several Oracle versions (particularly 11.2.0.2 patches) with a focus on rectifying incorrect index costing, optimizer estimations, and view-related mishandlings. Key bug fixes include adjustments to index skip scans and index access plans to improve the query execution planning within SAP environments utilizing Oracle databases. This note details remediations for known issues, ensuring enhanced database performance and reliability.
Key words :
' 9885553 - dbms_stats producing incorrect column distinct values statistics 10134677 - join selectivity, dbms_stats producing incorrect column distinct values statistics 12622441, dbms_stats producing incorrect column distinct values statistics 12794025, complex bi queries14081330 - optimizer merge label request, star_transformation_enabled = true 13524237 - unneeded temporary tables created, locked table statistics 14254795 - index skip scan cost, temp table 13524237 - unneeded temporary tables created, first_rows_k join 13262857 - index clustering factor computation, global index multiple times 13040171 - bad performance, global index multiple times 13040171 - bad performance
Related Notes :
| 1597736 | GI 11.2.0: Patches / Patch Collections for 11.2.0.2 |
| 1591389 | Exadata 11.2.0: Patches for 11.2.0.2 |
| 1503709 | Oracle 11.2.0: Patches / Patch collections for 11.2.0.2 |
| 1431798 | Oracle 11.2.0: Database Parameter Settings |