Oracle 9i Performance issues

Oracle 9i, specifically release 9.2.04 has problems determining which index to use when executing certain queries. In other words, Oracle sometimes uses the wrong index or sometimes uses no index resulting in potentially severe performance problems for some APPX processes. The good news is that this problem is supposedly fixed in release 9.2.06.