Re: 10gR2 Performance sux!

  • From: amit poddar <amit.poddar@xxxxxxxx>
  • To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Thu, 14 Jun 2007 09:09:03 -0400

Can you set any parameter  the way you mentioned ?
If yes than does thatn mean opt_param is not required at all ?

amit

Christian Antognini wrote:
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



Other related posts: