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 upg…

Here are some things you can do. Did you collect statistics on the SYS schema after the database ugprade? Do so if you did not. It doesn’t hurt to do that again if you aren’t sure. I’ll paste in a script to do that at the end of this reply. It looks like you are logged as one user (KNL) …

Hello John, Thank you for the your quick reply. I had already gathered stats but I did it again as well as the additional recommended steps but I still don’t have an acceptable wait when loading the Script tab. For some objects it takes significantly longer to load the data than others. I’ll try to…

You might want to also update your Toad. We just released version 12.12 a few days ago. I’ve made improvements to some of those queries over the years.

I got exactly the same problem. I moved to Toad for Oracle 13.1 -> still slow GRANT SELECT ANY DICTIONARY TO xxx --> still slow GRANT SELECT_CATALOG_ROLE TO xxx --> still slow I'm connected to an Oracle 12.2.0.1.0. I have used Toad for years with Oracle db 12.1 and Toad 12.9 without any problem…

Read this if you recently upgraded your database: [image] Toad 12.1 hangs for long when connecting to database via oracle connection manager Toad for Oracle Hi, Thanks for the guidance, I worked with developer to trace the Toad session and below are the findings while c…

I can query easily "select count(*) from sys.all_synonyms; " (less than 1 seconds to respnd / 8000 synonyms). Here is my spool screen output when I tried to launch schema browser ... it tooks around 1 minute the first time, then it takes 10 seconds if I'm reopening it ... -- Session: PBRABANT@BCP…

When you send me a spool SQL, it is better to send the whole thing, so that I can see how long certain queries are taking. For now, I will assume the one you showed me is executing slowly. Sometimes user_all_tables is slow, but user_tables is fast. You can make Toad query user_tables instead by …

I send you the whole output .... it contains just this statement (no other statements) ... I just exclude "Object tables" / I'll keep you informed.

Schema Browser Slow after migration to 12c

Toad for Oracle & DevOps Toolkit

JohnDorlon April 16, 2019, 12:33pm 6

Read this if you recently upgraded your database:

Topic		Replies	Views
Slow schema browser startup with oracle 12c rel2 Toad for Oracle & DevOps Toolkit	7	1050	November 17, 2020
Getting a Slow performance in Toad for Oracle 12.10 when I am trying to open Schema Browser \| Script Tab. Toad for Oracle - Beta	10	3526	September 22, 2017
Schema Browser slow in Packages Toad for Oracle - Beta	10	1680	March 12, 2014
Schema Browser Script slow Toad for Oracle & DevOps Toolkit	5	1551	March 21, 2019
How to speed up schema browser using toad for oracle 12c database, including RAC Toad for Oracle & DevOps Toolkit	40	9118	January 17, 2025

Schema Browser Slow after migration to 12c

Related topics