Despite of all goods synonyms got also drawbacks: Let me quote Steve Adams on this:Public synonyms should be entirely avoided in high concurrency environments. The memory wasted is proportional to the number of public synonyms in use, times the number of users. The performance cost is mainly in terms of increased latching in the shared pool and library cache.
This script shows the number of users for each public synonym in use.This indicates whether there is any risk of potential performance problems due to public synonyms
More details here: http://www.ixora.com.au/scripts/library.htm look for public_synonym_users.sql Regards. Greg ---------------------------------------------------------------------- Duzi chlopcy lubia wampiry i krew. http://linkint.pl/f2718 -- //www.freelists.org/webpage/oracle-l