Oracle Database Links Report
This script displays information about all database links configured in the Oracle database. It queries the DBA_DB_LINKS view to show link owner, database link name, username, and host, helping DBAs review and manage database connectivity between systems.
oraclesqlreporting-analyticsv1.0.0
0 stars0 downloads15 views0 comments
By OracleDba • Created
Code
(21 lines)123456789101112131415161718192021
-- -----------------------------------------------------------------------------------
-- File Name : https://oracle-base.com/dba/monitoring/db_links.sql
-- Author : Tim Hall
-- Description : Displays information on all database links.
-- Requirements : Access to the DBA views.
-- Call Syntax : @db_links
-- Last Modified: 11/05/2007
-- -----------------------------------------------------------------------------------
SET LINESIZE 150
COLUMN owner FORMAT A30
COLUMN db_link FORMAT A30
COLUMN username FORMAT A30
COLUMN host FORMAT A30
SELECT owner,
db_link,
username,
host
FROM dba_db_links
ORDER BY owner, db_link;