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 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 :

  • dg_row for dictionary gets

  • dm_row for dictionary misses

  • dcr_row for dictionary cache hit rate

  • bcr_row for buffer cache hit ratio

  • dsr_row for disk sort ratio

  • bbw_row for buffer busy wait ratio

  • fbw_row for free buffer wait ratio

  • lchr_row for library cache get hit ratio

  • lcpr_row for redo space wait ratio

  • lcpr_row for library cache pin hit ratio

  • rswr_row for redo space wait ratio

  • cfr_row for chained fetch ratio

  • per_row for parse/execute ratio

  • cpo_row for CPU parse overhead

  • tsr_row for ratio of rows from idx/total rows

  • dbwra_row for DBWR avg scan depth

  • dbwrs_row for DBWR avg buffers scanned

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 


TOAD Handbook
TOAD Handbook (2nd Edition)
ISBN: 0321649109
EAN: 2147483647
Year: 2003
Pages: 171

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net