We have a large number of objects and whenever I try to use the Compare function in Schema Browser, it is very slow to load the list of objects...even when I right-click and select Compare on a specific package. Is there anything that can be done to speed this up?

I did make a change here for 17. Go to options tab and make sure "Limit Object Type dropdown to available objects" is unchecked. It is faster with that box unchecked. If it is still too slow, turn on spool SQL so you can get timings of the background queries and post them here. Maybe there is…

Schema Browser - Compare code

Toad for Oracle & DevOps Toolkit

dosborne August 14, 2024, 9:44pm 21

Finally got upgraded. Love the performance boost!

1 Like

Topic		Replies	Views
Schema compare slow Toad for Oracle & DevOps Toolkit	4	1778	April 13, 2015
Why does schema Compare take longer in smaller schema Toad for Oracle - Beta	5	964	September 19, 2013
Beta Released (12.9.0.26) Toad for Oracle - Beta	0	686	February 10, 2016
Slow schema browser startup with oracle 12c rel2 Toad for Oracle & DevOps Toolkit	7	1050	November 17, 2020
Question on schema with many objects Toad for Oracle & DevOps Toolkit	5	533	October 17, 2013

Schema Browser - Compare code

Related topics