DBA_SYNONYMS view tips

Oracle Tips by Burleson Consulting

DBA_SYNONYMS

<< Return to the index

Oracle 11g makes the following comments about the DBA_SYNONYMS table: "All synonyms in the database"

Related notes on DBA_SYNONYMS:

Column description of the DBA_SYNONYMS view:

OWNER

Description of DBA_SYNONYMS.OWNER: "Username of the owner of the synonym"

SYNONYM_NAME

Description of DBA_SYNONYMS.SYNONYM_NAME: "Name of the synonym"

TABLE_OWNER

Description of DBA_SYNONYMS.TABLE_OWNER: "Owner of the object referenced by the synonym"

TABLE_NAME

Description of DBA_SYNONYMS.TABLE_NAME: "Name of the object referenced by the synonym"

DB_LINK

Description of DBA_SYNONYMS.DB_LINK: "Name of the database link referenced in a remote synonym"

DBA_SYNONYMS View Source

Oracle 11g's data dictionary defines the DBA_SYNONYMS view using the following source query:

select u.name, o.name, s.owner, s.name, s.node
from sys.user$ u, sys.syn$ s, sys."_CURRENT_EDITION_OBJ" o
where o.obj# = s.obj#
and o.type# = 5
and o.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

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books