One of the best notes in MOS got refreshed last night for Oracle Database 188.8.131.52. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the “sleeping beauties” as you as a DBA usually won’t recognize them. It is recognized at the application level when the result of a report is incorrect or instead of 4 rows just 3 rows get delivered in the output. Therefore you should be highly aware of those and add this note to your bookmarks.
MOS Note 1645862.1: Things to Consider Before Upgrading to 184.108.40.206 to Avoid Poor Performance or Wrong Results
And in case you don’t want to move to Oracle 220.127.116.11 but searching for information and known issues in Oracle 18.104.22.168 or Oracle 22.214.171.124 then please find the corresponding documents:
- MOS Note: 1320966.1 Things to Consider Before Upgrading to 126.96.36.199.x to Avoid Poor Performance or Wrong Results
- MOS Note: 1392633.1 Things to Consider Before Upgrading to 188.8.131.52 to Avoid Poor Performance or Wrong Results