Re: Performance Problem
- From: "Alex Gorbachev" <ag@xxxxxxxxxxxx>
- To: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>
- Date: Sun, 4 Nov 2007 12:28:59 -0500
Thanks Wolfgang. Sounds encouraging.
On Nov 4, 2007 11:03 AM, Wolfgang Breitling <breitliw@xxxxxxxxxxxxx> wrote:
> I have worked with several Peoplesoft databases running the gamut
> from HR, SA (Student Admin), Financials/Supply Chain and EPM on
> Oracle 9i and 10g and none of them has optimizer_features_enable
> "backdated". We set specific _ parameters though:
> _unnest_subquery=false
> _complex_view_merging=false
> _gby_hash_aggregation_enabled = false ( nothing to do with
> Peoplesoft but the default true can produce wrong results ).
>
> At 01:14 AM 11/4/2007, "Alex Gorbachev" <ag@xxxxxxxxxxxx> wrote:
>
> >I don't have much Peoplesoft experience and I know that administrators
> >of such applications are typically conservative. However, sticking to
> >OPTIMIZER_FEATURES_ENABLE=8.1.7 without attempt to make use of all new
> >CBO features of latest Oracle releases is a short sighted approach. Is
> >anyone running Peoplesoft on 10g without
> >OPTIMIZER_FEATURES_ENABLE=8.1.7?
>
> Regards
>
> Wolfgang Breitling
> Centrex Consulting Corporation
> www.centrexcc.com
>
>
--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
