This screen provides information about local and global buffer performance. The following information is examined: o Asynchronous Prefetch status o Detected Asynchronous Prefetch status o Asynchronous Batch Write status o Ratio of local buffers to allocate set You can use the information in this screen to examine the effectiveness of local and global buffers. Information in the Buffer Analysis screen is displayed only if it exceeds established threshold values or normal expectations. Note that the items identified in this screen are not necessarily indications of performance problems. The items may be an indication of a performance problem, but in most cases, further research is necessary. The Buffer Analysis screen has a configuration submenu that allows you to set thresholds for the following: o LB/AS page hit threshold The default threshold is 75. You can override the default value with the RDM$BIND_STATS_LB_PAGE_HIT_RATIO logical name. o GB pool hit threshold The default threshold is 85. You can override the default value with the RDM$BIND_STATS_GB_POOL_HIT_RATIO logical name. o GB IO-saved threshold The default threshold is 85. You can override the default value with the RDM$BIND_STATS_GB_IO_SAVED_RATIO logical name. Note that the Online Analysis facility uses the actual database parameters and attributes specified using interactive SQL. The Online Analysis facility does not use the Dashboard facility because the Database Dashboard attributes are temporary settings. Therefore, online changes made using the Dashboard facility are not reflected in the analysis output. Yet, using the Dashboard facility is the recommended method for testing potential database attribute settings. You must use interactive SQL in order to make the attribute settings persistent. Also note that the Online Analysis facility is invoked at the designated screen refresh interval. As the Online Analysis facility is fairly CPU intensive, and the analysis results seldom vary greatly over a miniscule period of time, it is recommended that the screen refresh interval be set to 3 seconds or more. The Buffer Analysis screen is not recorded in the binary output file produced using the Output qualifier. Consequently, this screen is not available when you replay a binary file using the Input qualifier.