Some code to capture link usage

select db_link, dba_users.username, sql_text
from v$sqlarea a, dba_users, dba_db_links
where upper (sql_text) like
‘%@’ replace(replace (db_link, ‘.COMPANY’), ‘.WORLD’) ‘%’
and user_id=parsing_user_id
/

Advertisements