Oranew
asked on
Oracle Invalid synonyms
My Oracle Public Synonyms are invalid. Is this can cause performance problems?
the first time you reference the synonym you may lose a few milliseconds while it resolves the object and updates the status back to valid but other than that, no.
What happened to make them invalid? Did you do a database version upgrade, or something else recently that made them invalid?
ASKER
Appreciate your response on this but I wasn't aware when and how these public synonyms got invalid. I come to know when I queried one of the sql asked by oracle on one of the opened SR. There are more than 40k invalid public synonyms. Just to answer your question. .no ..not release upgrade but we do apply cpu patches quaterly
ASKER
Also, these objects are frequently accessed but i am not sure if application will use synonyms or directly access the objects like tables or views. Also, to update that there are no users who directly logged in to production database. It is only through online application
You haven't told us anything about your application. Some purchased applications use public synonyms and some do not. Most newer applications do not use them now. Do you have a purchased application, or a custom one? If purchased, which one is it?
ASKER
It is peoplesoft application
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.