From: Christian Antognini <>
Date: Wed, 25 Nov 2009 13:28:08 +0100
Message-ID: <>


> Does anyone know if opt_param hint works with
optimizer_features_enable in

IMHO it's not relevant to know whether it's supported or not. In fact, for that purpose, the hint optimizer_features_enable should be used. E.g.:

SELECT /*+ 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');

Or I'm missing something obvious?

Chris Antognini

Troubleshooting Oracle Performance, Apress 2008

Received on Wed Nov 25 2009 - 06:28:08 CST

Original text of this message