well momentarily, i got the solution by setting optimizer_features_enable='9.2.0'....
but i m willing to use the optimizer features of 10g later on...
is there any other way??