Re: OPT_PARAM

  • From: LS Cheng <exriscer@xxxxxxxxx>
  • To: hrishy <hrishys@xxxxxxxxxxx>
  • Date: Tue, 24 Nov 2009 11:54:00 +0100

Oh, no it does not work that is why I sent this post!

Thanks

--
LSC


On Tue, Nov 24, 2009 at 11:50 AM, hrishy <hrishys@xxxxxxxxxxx> wrote:

> oops no sorry that would only make your originaly query work .
>
> That would run your query below with optimizer_features_enabled to 9.2.0
>
> --- On *Tue, 24/11/09, LS Cheng <exriscer@xxxxxxxxx>* wrote:
>
>
> From: LS Cheng <exriscer@xxxxxxxxx>
> Subject: Re: OPT_PARAM
> To: "hrishy" <hrishys@xxxxxxxxxxx>
> Cc: "Dion Cho" <ukja.dion@xxxxxxxxx>, "Oracle Mailinglist" <
> oracle-l@xxxxxxxxxxxxx>
> Date: Tuesday, 24 November, 2009, 10:35
>
>
> That will get me a list...?
>
> Thanks
>
>
>
> On Tue, Nov 24, 2009 at 11:33 AM, hrishy 
> <hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx>
> > wrote:
>
>>   Hi
>>
>> This might just work
>>
>> ALTER SESSION SET EVENTS '10132 TRACE NAME CONTEXT FOREVER, LEVEL 1';
>>
>> SELECT
>> /*+ opt_param('optimizer_features_enable', '9.2.0')  */
>> x, y, z
>>  FROM v_lsc
>> WHERE x = 'S' OR y_date > to_date(:V1, 'MM/DD/YY HH24:MI:SS');
>> regards
>> Hrishy
>>
>>
>>
>>
>
>

Other related posts: