pros and cons of using synonyms for packages’ deployment

pts.
Tags:
Architecture/Design
SQL
Are there disadvantages to using synonyms for plsql packages from performance or maintenance point of view? Paulina.

Answer Wiki

Thanks. We'll let you know when a new response is added.

I haven’t encountered any performance or maintenance problems, but I have had various problems with synonyms across dblinks (on 8i at least).

Kai

Discuss This Question: 5  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Tuple9i
    I haven't found any real cons against using synonyms. As a matter of fact, I have had good experiences in reducing maintenance with changes in the DBMS. About the only problem is when you change an underlying object. You may have to recompile the package. Easy to do with dynamic SQL and part of my daily cron job list. As far as synonyms over dblinks. Make sure that the calling user has privileges on the underlying objects on both databases. Other than that, you shouldn't be having problems using them across links if they are setup correctly.
    0 pointsBadges:
    report
  • 17051966
    I have not had any negative impact from using synonyms for packages or other objects. The developers and testers find the use of synonyms helpful.
    0 pointsBadges:
    report
  • Abkeyte
    Yes, I believe using synonyms improves the maintainability of pl/sql objects, and improves security as well. I do not think it improves performance at all. It will be simpler to maintain and control though should it will improve the DBA's performance :-)
    0 pointsBadges:
    report
  • Punitnb
    I haven't encountered any performance or maintenance problems. Synonyms improves the maintainability of pl/sql objects and improves security of the underlying objects. I have not used it in distributed database. punit
    0 pointsBadges:
    report
  • ActorJack
    Synonyms are generally a good tool for code reuse. But I have to play the Devil's advocate here - there ARE some disadvantages. In general, you can't perform all the same actions on synonyms as you can or the objects they point to. E.g. you can't compile a synonym for a package. Regards, Kai
    0 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following