It works in my base test (on 11.2.0.4) - how are you speciying the hint?
My example is very simple and if I edit the sql to add /*+ driving_site(t2)
*/ then I get the required plan, but if I use an SQL patch to do this
Oracle reports that it "used" the patch, but the plan doesn't show the
remote as the driver. However, if I use the fully qualified alias /*+
driving_site(t2@sel$1) */ then the path is "used" and has the required
effect.
(The same was true for 19.3, so it's not an "old version" thing)
Regards
Jonathan Lewis
On Fri, 7 May 2021 at 19:29, Abdellah DANY <abd.dany@xxxxxxxxx> wrote:
I tried on a 11.2.0.4 but it seems not working.
On Fri, May 7, 2021, 17:20 Lothar Flatz <l.flatz@xxxxxxxxxx> wrote:
I never tried that one specifically, but it should work.
Regards
Lothar
Am 07.05.2021 um 17:58 schrieb Abdellah DANY:
Hi experts,
Is there a mean to inject driving_site hint to a query using sql patch?
Thanks