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 DBAServer 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 with far fewer bells and whistles than the Monitor Database screen. For example, it does not display a tray icon and thus has no possible animation. And the threshold values are not defined by using the TOAD Options screen, but by editing the TOADStats.ini text file in the TOAD TEMPS directory. The supported threshold categories are as follows :
Note that TOAD expects the TOADStats.ini text file to be in the standard Windows INI file format. For each INI file entry, you can define MIN, WARN, MAX, TITLE, and MESSAGE. When a warning threshold is crossed, the circular indicator on the Analysis tab will turn pink. When a maximum threshold is crossed, the circular indicator on the Analysis tab will turn red. A small sample of how to define these INI file settings is shown following: [lcpr_row] Title=Library Cache Pin Hit Ratio Min=80 Warn=90 ErrorMsg=Shared Pool area too small [per_row] Title=Parse to Execute Ratio Warn=17 Max=20 ErrorMsg=High parse to execute ratio |