Examining Server Statistics

Sometimes while troubleshooting database performance issues, you may prefer to see major database performance functional areas of key concern in a tabular or grid format. In other words you want similar information as what’s in the Monitor Database screen, but not displayed as graphs. In that case, you could run TOAD’s Server Statistics screen shown in Figure 6.58 and located on the main menu at DBA|Server Statistics. This screen breaks up that performance information into five tabs, of which only the first tab supports thresholds and messages based on crossing them. Of course, reasonable default thresholds are supplied.

Figure 6.58. TOAD Server Statistics screen.

Note that this is somewhat of an older-style screen ...

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.