I should have said - if you want to get the right "alias@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@xxxxxxxxx> 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@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
