Re: Sql patch and driving_site hint

Hi Jonathan,

Thanks for the update and for your blog note about the subject.

It is actually working the way you described it.

Thanks again for your help.

Regards,
Abdellah

On Sat, May 8, 2021, 10:09 Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> I should have said - if you want to get the right "alias_at_query_block"
> text then you could start by reporting the current execution plan with the
> ( format=>'alias' ) option to see the "Query Block / Object Alias"
> information, and that will give you the fully qualified name that you need
> to use.
>
> Regards
> Jonathan Lewis
>
>
> On Sat, 8 May 2021 at 10:54, Jonathan Lewis <jlewisoracle_at_gmail.com>
> wrote:
>
>>
>> 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
>>
>>
>>
>>

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