Search notes:

Oracle SQL Plan operation: REMOTE

explain plan for 
select
   rem.col_a,
   rem.col_b,
   rem.col_c,
   rem.col_d
from
   tab_local                loc                            join
   tab_remote@db.abc.xyz    pen on loc.id_x = rem.id_y
where
   loc.col_1 = 'abc'
;

select * from table(dbms_xplan.display(format=>'basic remote'));
--
-- ------------------------------------------------------------------------------------------------------
-- | Id  | Operation                                   | Name                           | Inst   |IN-OUT|
-- ------------------------------------------------------------------------------------------------------
-- |   0 | SELECT STATEMENT                            |                                |        |      |
-- |   1 |  HASH JOIN                                  |                                |        |      |
-- |   2 |   PARTITION RANGE ALL                       |                                |        |      |
-- |   3 |    TABLE ACCESS BY LOCAL INDEX ROWID BATCHED| TAB_LOCAL                      |        |      |
-- |   4 |     BITMAP CONVERSION TO ROWIDS             |                                |        |      |
-- |   5 |      BITMAP INDEX SINGLE VALUE              | TAB_LOCAL_IX_COL_1             |        |      |
-- |   6 |   REMOTE                                    | TAB_REMOTE                     |     DB | R->S |
-- ------------------------------------------------------------------------------------------------------
--
-- Remote SQL Information (identified by operation id):
-- ----------------------------------------------------
--
--    6 - SELECT "COL_A","COL_B","COL_C","COL_D" FROM "TAB_REMOTE " "REM" 
--        (accessing 'DB.ABC.XYZ' )

See also

The column named other of the plan_table stores the SQL statement executed on the remote site for the plan opterator remote.
Database links
Other plan operations such as SELECT STATEMENT REMOTE.
The name of the object addressed with the remote operator has no influence on the hash value of the execution plan.

Index