After upgrading to 9.2.0.6 we started to get slow response and incorrect query results. I ran into a bug, where the optimizer doesn't use Hash joins in the queries. This was unacceptable for me so I had to restore back to 9.2.0.5. Ray Stell wrote: >Note 547411.994 complains of slow performance after upgrading to >9.2.0.6. Anybody had a similar hit? >=============================================================== >Ray Stell stellr@xxxxxx (540) 231-4109 28^D >-- >//www.freelists.org/webpage/oracle-l > > > > -- LeRoy Kemnitz UW System Administration Database Administrator 780 Regent Street, #246 Madison, WI 53714 Phone: (608) 265 -5775 Fax: (608) 265 - 2090 -- //www.freelists.org/webpage/oracle-l