Oracle bug 3566843 can cause the Cost Based Optimizer to pick an inefficient index when there are multiple indexes to choose from. Oracle versions 22.214.171.124 through 126.96.36.199 and 10.1.0.1 through 10.1.0.3 are affected.
This problem only affects Maximo on Oracle databases. It can impact any version of Maximo using any Oracle 9i version less than 188.8.131.52, or any Oracle 10g version less than 10.1.0.4.
Due to Oracle bug 3566843, the Cost Based Optimizer may choose a less optimal index when there are multiple indexes on columns referenced in the where clause. This is more likely to affect SQL executed on tables with a large number of indexes, such as WORKORDER.
If you are running Maximo 4.1.1 patch 4 or higher, or any version of MAXIMO 5.x, you can patch/upgrade Oracle to version 184.108.40.206.
If you are running Maximo 6 or 7, you can patch/upgrade Oracle to version 220.127.116.11 or 10.1.0.4 or 10.2.0.x.
|Systems and Asset Management||Tivoli Asset Management for IT||All|
|Systems and Asset Management||IBM Maximo Asset Management Essentials||All|