When you click on MATERIALIZED VIEWS in SB (Toad 10.1 – Oracle 10g)) and
you have many MViews Toad takes forever to come back.
Before clicking on MViews in SB make sure you go to OPTIONS è HINTS and add a
hint of /*+ RULE */ for DBA_MVIEWS.
DBA_SNAPSHOTS is listed in the list but Toad 10.1 uses DBA_MVIEWS in the SB So
you need to add it. I suggest that For the next go around you include DBA_MVIEWS
in the list with an appropriate hint.