Checking Status of All Your Instances

One of the most important and routine tasks any DBA does is to check the status of their databases. In fact, what they really want to visually and very quickly ascertain is which:

  • Servers are down

  • Listeners are down

  • Instances are down

Of course, you could wait for the phone to ring or your pager to go off. But it is infinitely more desirable to have a compact and focused way to easily verify all this information. So TOAD provides the Instance Manager screen, which is located on the main menu at DBA, Instance Manager and depicted in Figure 5.1.

Figure 5.1. TOAD Instance Manager screen.

With this one screen, ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.