RE: 10gR2 Performance sux!

Amit

> don't you mean /*+ opt_param('optimizer_features_enabled', '9.0.1') */
?

No. I meant what I wrote, i.e.: /*+ optimizer_features_enable('9.0.1') */

Also notice that the name of the parameter in your example is wrong. There's no "d"...

HTH
Chris

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