DBLINK

DBA_DB_LINKS - All DB links defined in the database

ALL_DB_LINKS - All DB links the current user has access to

COL owner FORMAT A8;
COL USERNAME FORMAT A20;
COL DB_LINK FORMAT A20;
COL HOST FORMAT A25;
select * from ALL_DB_LINKS;

USER_DB_LINKS - All DB links owned by current user