Re: 10gR2 Performance sux!

From: amit poddar <amit.poddar_at_yale.edu>
Date: Thu, 14 Jun 2007 09:09:03 -0400
Message-ID: <46713DEF.8010902@yale.edu>

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
>
>
>

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

Received on Thu Jun 14 2007 - 08:09:03 CDT