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 |
-- -------------------------------------------------