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