Is there a function is Toad which can be used to find out what objects in the database are using the most resources?
The Top Session Finder window can help you do this. This feature is only available in the version of Toad with the optional DBA Module.
This window lets you find the sessions in the database that are consuming the most resources. You can operate the Top Session Finder in single parameter select mode or multiple parameter select mode.
Single parameter select mode lists sessions in order of resource usage. Multiple parameter select mode lets you assign weights to two or more parameters, and the sessions are sorted by the weighted sum of the statistics.
