Call (800) 766-1884 for Oracle support & training
Free Oracle Tips


Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

 

 

   
  Oracle Tips by Burleson

Monitoring Synonyms Using the V$ and DBA_ Views 

Synonyms remain the same in Oracle8, Oracle8i, and Oracle. The major changes that have affected synonyms are those to the structure of the connection strings from SQL*NET V1 to V2 to NET8. Despite the fact that synonyms are the key to providing cross-database access for queries, and a means of implementing distributed data across nodes, systems, and databases, in all the reports reviewed for this book, not one seemed to cover synonyms. Recall that a synonym allows a shorthand version of an object name to be specified. The parts of a synonym are the object name (which usually includes an owner) and, possibly, a database link that will also provide an Oracle user name and password to a remote system. A complete report will show all of these items.       

Why is it important to monitor synonyms? Synonyms can be used to access data, sometimes data that shouldn’t be accessed if object grants have been too widely granted. In addition, they are the means for reaching other nodes and databases. If a connect string becomes invalid, a user name is disconnected or its password changes or node name changes, it is good to be able to see which object synonyms will be affected. Source 11.20 shows a script for a synonym report, and Listing 11.17 shows an example of output from a synonym script.

See Code Depot


www.oracle-script.com

  
 

Oracle performance tuning software 
 
 
 
 

Oracle performance tuning book

 

 
 
 
Oracle performance Tuning 10g reference poster
 
 
 
Oracle training in Linux commands
 
Oracle training Excel
 
Oracle training & performance tuning books
 

 

   

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.