Re: Sql patch and driving_site hint

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_at_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_at_gmail.com> 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_at_bluewin.ch> 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
>>
>>

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