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