Re: Have you had any issues with 9.2.0.5

  • From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 9 Jul 2004 06:25:37 -0700 (PDT)

wolfgang,
had the same issues here in 9.2.0.4
the problem was 
_UNNEST_SUBQUERY this is set to true in 9.2
also 
we had to set this to false to get the merge join cartesion and the buffer 
sorts to go away.
there is alos a bug id bug # 3268590
the second parameter that can do this is
_optimizer_new_join_card_computation = true (default) in 9i 

Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
It may be specific to Peoplesoft, but at two different clients I have seen 
performance issues when going to 9.2.0.5. The CBO suddenly uses a lot of "merge 
join cartesian" with a "buffer sort" on the inner table. That causes a lot of 
problems when the estimated cardinality for the outer table is wrong.
The other thing I have seen are a lot more index skip scan accesses than 
before. Again, often not appropriate.

It may be a consequence of running without cpu costing (i.e. no system 
statistics in place).

Could you please post any interesting findings here.

Quoting "Loughmiller, Greg" :

> If you all could be so kind, could you please share any negative experience
> that you all have had by using 9205? Specifically, any bugs/issues that you
> have encountered while using 9.2.0.5. 
> 
> In addition, for those who are using Oracle Apps and 9205 would be of
> special interest.
> 
-- 
Regards

Wolfgang Breitling
Oracle 7,8,8i,9i OCP DBA
Centrex Consulting Corporation
www.centrexcc.com

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: