Oracle database is a very complex software, and as we all know, has bugs. Oracle tries to address these bugs, and fixes a lot of them all the time. Except specific fixes, they publish patchsets (which might introduce more than only bug fixes) and PSUs. If you are not aware of these patch types and how it works, you are welcome to read my post about it here.
Many times, people ask me about bugs that were fixed in a patchset/PSU. So I decided to write this to let you know that Oracle publishes the full list of bugs for each patchset and PSU. It was a “hobby” of mine a few years back to look at the list and find the weirdest and most unbelievable bugs (yeah, I’m a geek, I know).
If you simply login to MOS and look for the exact 4 digit version and “list of fixes” you’ll find it immediately. For example, note 1683802.1 contains all the bugs that got fixed in 18.104.22.168 (meaning they existed in 22.214.171.124), and note 1562142.1 contains the list of bugs that got fixed in 126.96.36.199 (existed in 188.8.131.52).
Another important thing to know is that Oracle also provides information about known issues. If you search the version and “known issues” you will found notes like 1562139.1 (known issues in 184.108.40.206) and 1683799.1 (known issues in 220.127.116.11).
Both “list of fixes” and “known issues” lists exist for PSUs as well. The “list of fixes” notes look a bit different for PSU, like note 1924126.1 (called 18.104.22.168 Patch Set Updates – List of Fixes in each PSU).