I am not a DBA, but that doesn’t mean I lack respect for how difficult planned upgrades can be in complex Enterprise deployments. If I was a DBA planning an upgrade of my Oracle Database 10g Release 2 database I would be looking forward to 10.2.0.4. From what I’ve seen it looks like a pretty substantial release. Metalink 401436.1 spells out some of the bugs that could/should be fixed in the 10.2.0.4 release.
Those of you who have read my NUMA-related posts might be interested to know that Metalink 401436.1 lists bug 5173642 as once of the bugs that could/should be fixed in 10.2.0.4. That bug was essentially a deadline on NUMA optimizations in 10gR2 as is clear by the specified workaround:
Workaround: Do not use NUMA optimization. eg: Set the following init.ora parameters: _enable_numa_optimization=FALSE