Search notes:

Oracle SQL Plan operation DATA LINK

Find a random table with DATA LINK sharing:
select
   tab.table_name
from
    dba_objects obj   join
    dba_tables  tab on obj.object_name = tab.table_name
where
   obj.sharing = 'DATA LINK';
--
-- SYSTEM_PRIVILEGE_MAP
-- TABLE_PRIVILEGE_MAP
-- USER_PRIVILEGE_MAP
-- STMT_AUDIT_OPTION_MAP
-- …
Then find the plan for selecting from this table from a PDB:
explain plan for
select * from system_privilege_map;

select * from dbms_xplan.display(format=>'basic');
--
-- -------------------------------------------------
-- | Id  | Operation        | Name                 |
-- -------------------------------------------------
-- |   0 | SELECT STATEMENT |                      |
-- |   1 |  DATA LINK FULL  | SYSTEM_PRIVILEGE_MAP |
-- -------------------------------------------------

See also

EXTENDED DATA LINK FULL
Plan operations

Index