I have a family of databases which is being migrated from 11g to 12c version. For all databases migrated so far we have experienced slowness when using Schema Browser on Toad, particularly the Script tab. Will you please advise how we can at least restore performance level to how it was prior to upgrade? Sometimes it can take as much as 25 seconds to load the DDL for a table. I have enclosed 2 files, each containing the Database Spool for the database on 11g and the other for 12c. My TOAD version is 126.96.36.199.
SpoolPRD2A_12c_24102017.txt (18.5 KB)