Re: Optimizer change from 8i-9i

From: zhu chao <zhuchao_at_gmail.com>
Date: Tue, 10 May 2005 15:15:03 +0800
Message-ID: <962cf44b050510001578f5316b@mail.gmail.com>

Hi, Gogala,

    Wolfgang Breitling's document is great, but it does not answer my questions.

    When we set optimizer_features_enable=3D8.1.7, all the new features got disabled. (Not sure about the new costing modle.).

    If the new costing modle is also changed, this can change the plan in CBO even if we keep optimizer_features_enable=3D817 and don't re-analyze the tables. I will try to figure it out.   =20
Thanks
Chao

On 5/10/05, Mladen Gogala <mgogala_at_allegientsystems.com> wrote:
> Christian Antognini wrote:

>=20


> >Let me precise this point...=3D20

> >
> >

>=20

> Let me make it even more precise:

>=20
> http://www.centrexcc.com/What%20is%20new%20in%20the%20Oracle%209i%20CBO.p=
df

>=20

> --
> Mladen Gogala
> Oracle DBA
> Ext. 121

>=20
>=20

--=20
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 10 2005 - 03:19:35 CDT