Re: CBO in Oracle Apps R11 11.0.3

From: Hemant K Chitale <hkchital_nospam_at_singnet_nospam.com.sg>
Date: Thu, 30 May 2002 21:50:17 +0800
Message-ID: <ad5all$30t$1@coco.singnet.com.sg>

Thanx.

I plan to try switching to CHOOSE.
I had been using ANALYZE in all my
pre-8.1.7 databases. I have now begun
to start using DBMS_STATS but haven't
done it for the R11 database yet.

Hemant K Chitale

"Daniel Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3CF4FC7D.44A5E0F4_at_exesolutions.com...
> Hemant K Chitale wrote:
>
> > Has anyone set OPTIMIZER_MODE to CHOOSE
> > in an Oracle Applications R11 11.0.3 environment ?
> >
> > The recommended (or required/supported) value with R11 when it was
> > released against 8.0.4 was RULE. We've upgraded
> > to 8.1.7 and I wonder if I can switch to CHOOSE
> > with better statistics collection and improvements
> > in the Optimizer.
> >
> > Hemant K Chitale
>
> Yes.
>
> And use DBMS_STATS to collect statistics ... not the old analyze.
>
> Daniel Morgan
>
Received on Thu May 30 2002 - 08:50:17 CDT