Toad World® Forums

Schema Browser???

I have use schema browser on Toad. It’s hangs while query table, but I can used sql plus. What should I do?

Shinchan,

Are you working with databases with a large number of objects?

I use TOAD on many different databases. Toad works well on all except 2. Both of those databases are Oracle 8 and have tens of thousands of tables and views. For those two databases, opening TOAD is very slow (over 2 minutes), and the first display of tables in the schema browser is extremely slow (up to a minute). If I wait, TOAD will eventually display.

Once these things get loaded, TOAD works normally.

-Brian

If you want to prevent the schema browser from loading lots of objects when you
first open it, you can go to Options -> Schema Browser -> Left Hand Side,
and check “Show Filter Dialog before refreshing”. This will give you
a chance to limit the # of objects loaded before any query is executed.