There are so many useful little make or break features inside Toad, it’s very often difficult to pick one to highlight. A few weeks ago I started to divulge some things
coming in Toad 9.7 (and already in the beta). One item I mentioned was the enhancements to the Database Browser, where most DBA screens and/or utilities can now be launched via a right hand mouse menu option. This can almost eliminate the need to launch those items from the Main Menu->Database list of menu options. But the Database Browser has been around for a while now – and it has one very cool feature that makes it indispensible!
Have you ever needed to know what resources were being consumed by all the databases on a shared server? Well, the database browser makes short work of that task, and for all of the more useful things one might need to measure. Look at the screen snapshot below. If you either select the server node or multi-select databases under that node, the Database Browser shows all the associated information in the data grid. But look at the area near the bottom circled red – it also shows the cumulative statistics for all those databases. So here I can see that my two databases use 8.6 GB of disk space, of which 7.8 GB are used. And this feature works like this for all the tabs that make sense.