 |
|
DBA_DB_LINKS view tips
Oracle Tips by Burleson Consulting |
DBA_DB_LINKS
<< Return to the index
Oracle 11g makes the following comments about the DBA_DB_LINKS table: "All database links in the database"
Related notes on DBA_DB_LINKS:
Column description of the DBA_DB_LINKS view:OWNERNo comments exist for the OWNER column of the DBA_DB_LINKS table. DB_LINKDescription of DBA_DB_LINKS.DB_LINK: "Name of the database link" USERNAMEDescription of DBA_DB_LINKS.USERNAME: "Name of user to log on as" HOSTDescription of DBA_DB_LINKS.HOST: "SQL*Net string for connect" CREATEDDescription of DBA_DB_LINKS.CREATED: "Creation time of the database link"
DBA_DB_LINKS View SourceOracle 11g's data dictionary defines the DBA_DB_LINKS view using the following source query:
select u.name, l.name, l.userid, l.host, l.ctime
from sys.link$ l, sys.user$ u
where l.owner# = u.user#
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|