Schema Browser Slow after migration to 12c

[JohnDorlon]

Read this if you recently upgraded your database:

Toad 12.1 hangs for long when connecting to database via oracle connection manager

Hi, Thanks for the guidance, I worked with developer to trace the Toad session and below are the findings while connecting to PDB(pluggable) Oracle Database, there is a package (not DB stored package) which is being executed for every session whenever user connects from TOAD. While debugging , developer has found that ALL_SYNONYMS is used in the package where it is taking long time to execute, and that block is being errored out with "ORA-03113 end-of-file on communication channel". select c…