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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
