Inefficient queries to ALL_SYNONYMS
When querying ALL_SYNONYMS in a database with too many objects, performance can be impacted by SYS.OBJ$ full scan, which can't be avoided.