Re: Have you had any issues with 9.2.0.5

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_at_centrexcc.com> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://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_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------