Re: OPT_PARAM

  • From: hrishy <hrishys@xxxxxxxxxxx>
  • To: Dion Cho <ukja.dion@xxxxxxxxx>, exriscer@xxxxxxxxx
  • Date: Tue, 24 Nov 2009 10:33:01 +0000 (GMT)

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:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2009