How do you find out which database links are used in queries for the Oracle RDBMS?

database, oracle

Solution

This will show you any database links set up on the database:

select * from dba_db_links;

You would then have to search for any queries or objects using the db link by doing a text search of them for the link syntax `<tablename>@<dblink name>`

Problem

I would like to find out if any and which database links are being used, for a schema, and in which tables. Is it possible via the data dictionary somehow? Is this possible with the Oracle RDBMS?

Original source