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

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 Received on Wed Jul 13 2005 - 01:37:28 CDT