I find that some of the SB tabs dealing with MVs are quite slow. I wonder if it
has something to do with the view being used. I notice that on our system (an
11g system) DBA_MVIEWS is very much slower than DBA_SNAPSHOTS. To show 543 MVs
DBA_MVIEWS takes over 40 seconds while DBA_SNAPSHOTS takes on 3 seconds.
I am writing this just in case some of the Toad scripts use DBA_MVIEWS instead
of DBA_SNAPSHOTS and could be changed in Toad 10.6.
Though for us it is probably not a big deal because our current servers are end
of life and we are going to real computers in the fall.