Monitoring a Database Instance

On occasion, database performance becomes an issue and demands a DBA’s attention. No matter how hard the DBA tries, the following bad performance scenario always happens. The telephone rings, the pager goes off, or someone walks into your cubicle because all of a sudden and without cause, database performance came to a grinding halt. Moreover, it’s always the case that no one has changed anything or has issued a questionable query. They all swear it happened suddenly and for absolutely no reason. No one is ever to blame.

Fortunately TOAD has a screen for high-level monitoring exactly what’s going on inside the database, and thus exposes why its performance has tanked—it’s the Monitor Database screen, shown in Figures ...

Get TOAD® Handbook now with the O’Reilly learning platform.

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