Progress
Database Administration
Guide and Reference


Activity Displays>Buffer Cache

Displays activity information about the database buffer cache (also called the buffer pool). Figure A–23 shows a sample Buffer Cache Activity display.

01/25/02               Activity: Buffer Cache 
16:28                  from 01/25/02 13:56 to 01/25/02 13:57 (19 sec) 
                          Total       Per Min      Per Sec     Per Tx 
Logical Reads             23          73           1.21        0.00 
Logical Writes            0           0            0.00        0.00 
O/S reads                 8           25           0.42        0.00 
O/S writes                2           6            0.10        0.00 
Checkpoints               0           0            0.00        0.00 
Marked at checkpoint      0           0            0.00        0.00 
Flushed at checkpoint     0           0            0.00        0.00 
Writes deferred           0           0            0.00        0.00 
LRU skips                 0           0            0.00        0.00 
LRU writes                0           0            0.00        0.00 
APW Enqueues              0           0            0.00        0.00 
Hit Ratio: 68 % 

Figure A–23: PROMON Buffer Cache Activity Display

The display lists the following types of buffer cache requests:


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095