We have recently upgrade to Oracle 10g, from 9.2, and have found a number of issues. In particular, we have found that query performance can be seriously degraded. One workaround is to revert to Oracle 9.2 optimiser behaviour by wrapping the query with ...
EXECUTE IMMEDIATE 'alter session set...