Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Slow performance after upgrading to 9.2.0.6

Re: Slow performance after upgrading to 9.2.0.6

From: LeRoy Kemnitz <lkemnitz_at_uwsa.edu>
Date: Tue, 15 Feb 2005 14:45:09 -0600
Message-ID: <42125F55.9000906@uwsa.edu>


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_at_vt.edu (540) 231-4109 28^D
>--
>http://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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 15 2005 - 15:47:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US