4.201 DBA_DB_LINK_SOURCES
DBA_DB_LINK_SOURCES
identifies all unique source databases that opened database links to the local database.
By default, only a DBA has access to this view. However, a DBA can grant access to this view to others.
This view is based on a persistent table that resides in the same system tablespace that is used by Database Auditing.
In a multitenant container database (CDB) environment, for every DBA_ view, there is a corresponding CDB_ view that contains data for all the pluggable databases (PDBs) in the CDB. A query on the CDB_DB_LINK_SOURCES
view done in the CDB$ROOT
container will show sources of all the database links recorded in all PDBs. A query on the corresponding DBA_DB_LINK_SOURCES
view done in a PDB show information corresponding to that PDB only (that is, where that specific PDB was the target of an inbound database link).
Note that the CDB_ views would only show data from PDBs that are open at the time the query is issued. Therefore, when you are diagnosing sources of database links, Oracle recommends that you keep open any or all PDBs that might contain useful information for the diagnosis.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique ID that identifies an incoming database link |
|
|
|
Global name of the source database |
|
|
|
Database identifier of the source database. Maps to the |
|
|
|
Unique database name of the source database. Maps to the |
|
|
|
Resolved host name. Null if not available. |
|
|
|
IP address of source machine. Null if not available. |
|
|
|
One of supported protocols such as |
|
|
|
Oracle username of the user who logged into the local database. Maps to the |
|
|
|
Oracle user id of the user who logged into the local database. Maps to the |
|
|
|
The timestamp of the first connection on this database link in UTC |
|
|
|
The timestamp of the last connection on this database link in UTC |
|
|
|
Number of times connection has been established through this database link |
See Also: