I have inherited a database with over 3 million objects - not particularly big and indeed most are private synonyms... I have looked at introducing public synonyms , but this does not work with the application.
Short term I need to optimise the db to be able to cope with a data dictionary with so many objects. Looking for ideas...

Thanks