When I read Note: 391116.1 with the full list, I noticed the following bugs that we’ve encountered are fixed.
- the ‘hash group by’ bug with incorrect results: bug 4604970
- the listener may hang in RAC: bug 4518443
- ora-600  on multitable join – a problem with histograms described in Note:371333.1 and Bug 5041016
Unfortunately, an important bug in 10.2.0.2 posted on the Sept. 29 is not listed as fixed in this patch list. The bug has to do with both data corruption, and security vulnerabilities when running queries that can be interpreted in multiple ways by the SQL parser — depending on what schema has namespace precedence for your signon. In this regard, I would recommend anyone who is running, for example, a test or development copy of their production schemas on the same database, to read the following metalink note without delay.
Interested in working with Christo? Schedule a tech call.