Re: OPT_PARAM

From: LS Cheng <exriscer_at_gmail.com>
Date: Tue, 24 Nov 2009 11:54:00 +0100
Message-ID: <6e9345580911240254i6047707tfb071f7cb7f30e8_at_mail.gmail.com>

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_at_yahoo.co.uk> 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_at_gmail.com>* wrote:

>

>

> From: LS Cheng <exriscer_at_gmail.com>

> Subject: Re: OPT_PARAM

> To: "hrishy" <hrishys_at_yahoo.co.uk>

> Cc: "Dion Cho" <ukja.dion_at_gmail.com>, "Oracle Mailinglist" <

> oracle-l_at_freelists.org>

> 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_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>

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

>>

>>

>>

>>

>

>


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

Received on Tue Nov 24 2009 - 04:54:00 CST