One of the best notes in MOS got refreshed last night for Oracle Database 184.108.40.206. 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 220.127.116.11 to Avoid Poor Performance or Wrong Results
And in case you don’t want to move to Oracle 18.104.22.168 but searching for information and known issues in Oracle 22.214.171.124 or Oracle 126.96.36.199 then please find the corresponding documents:
- MOS Note: 1320966.1 Things to Consider Before Upgrading to 188.8.131.52.x to Avoid Poor Performance or Wrong Results
- MOS Note: 1392633.1 Things to Consider Before Upgrading to 184.108.40.206 to Avoid Poor Performance or Wrong Results