Re: optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?

"chao_ping" <zhuchao_at_gmail.com> wrote in message news:1121236648.759298.79320_at_g44g2000cwa.googlegroups.com...
> Hi, All,
> I noticed for this parameter optimizer_features_enable , oracle
> document says:
> Syntax
> OPTIMIZER_FEATURES_ENABLE = {8.0.0 | 8.0.3 | 8.0.4 | 8.0.5 | 8.0.6 |
> 8.0.7 | 8.1.0 | 8.1.3 | 8.1.4 | 8.1.5 | 8.1.6 | 8.1.7 | 9.0.0 | 9.0.1 |
> 9.2.0}
>
>
> I noticed when I keep it default to 9.2.0 in init.ora, in version
> 9.2.0.3 and 9.2.0.5 with exact same database and exact same init.ora,
> oracle CBO did choose different plan.
>
> So there is some difference between 9.2.0.X versioin for the CBO.
> Where can we get such information about the difference?
>
> Thanks
>

There are various bug fixes and tiny enhancements that don't count as features in 9.2.0.4 and 9.2.0.5 (and the rest of them). Such things are rarely documented in any way that could allow you to find them without being quite lucky.

-- 
Regards

Jonathan Lewis

Now waiting on the publishers:    Cost Based Oracle - Volume 1

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 8th July 2005