Database Management Technology 
The dmf_cache_stats table contains data page cache statistics accumulated for all connected database servers. One row is returned for each enabled page size. The delta columns represent the change in counter values in the last interval.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| server | 1 | varchar(64) | Database server name. |
| page_size | 2 | integer4 | Page size for the current cache in bytes. |
| checks | 0 | integer4 | Count of page valid checks performed on the cache. |
| checks_d | 0 | integer4 | Count of page check operations in the last interval. |
| clock | 0 | integer4 | |
| dirty | 0 | integer4 | Count of dirty (modified) pages unfixed. |
| dirty_d | 0 | integer4 | Count of modified pages unfixed in the last interval. |
| single_free | 0 | integer4 | Current count of free single page buffers. |
| single_free_d | 0 | integer4 | Count of single pages marked free in the last interval. |
| single_fixed | 0 | integer4 | Count of single page buffers currently fixed. |
| single_fixed_d | 0 | integer4 | Count of single pages fixed in the last interval. |
| single_modified | 0 | integer4 | Current count of modified single page buffers. |
| single_modified_d | 0 | integer4 | Count of single pages modified in the last interval. |
| fcwait | 0 | integer4 | Count of page waits caused by fast commit processing. |
| fcwait_d | 0 | integer4 | Count of fast commit wait operations in the last interval. |
| fix_calls | 0 | integer4 | Count of page fix operations, a fix occurs whenever a page is referenced by a running query. |
| fix_calls_d | 0 | integer4 | Count of fix calls in the last interval. |
| force | 0 | integer4 | Count of modified pages forced to the database. |
| force_d | 0 | integer4 | Count of pages forced to disk in the last interval. |
| fwait | 0 | integer4 | Count of free buffer waits. |
| fwait_d | 0 | integer4 | Count of free page waits in the last interval. |
| group_free | 0 | integer4 | Count of group buffers currently free. |
| group_free_d | 0 | integer4 | Count of group buffers freed in the last interval. |
| group_fixed | 0 | integer4 | Count of group buffers currently fixed. |
| group_fixed_d | 0 | integer4 | Count of group buffer fix operations in the last interval. |
| group_modified | 0 | integer4 | Count of group buffers currently modified. |
| group_modified_d | 0 | integer4 | Count of group buffer modify operations in the last interval. |
| group_reads | 0 | integer4 | Count of group read (readahead) operations performed. |
| group_reads_d | 0 | integer4 | Count of group buffer read operations in the last interval. |
| gsyncwr | 0 | integer4 | Count of group buffer synch operations. |
| gsyncwr_d | 0 | integer4 | Count of group buffer synch operations in the last interval. |
| gwait | 0 | integer4 | Count of group buffer stalls, a stall occurs where there are no available group buffers. |
| gwait_d | 0 | integer4 | Count of group buffer free waits in the last interval. |
| group_writes | 0 | integer4 | Count of group writes operations performed. |
| group_writes_d | 0 | integer4 | Count of group buffer write operations in the last interval. |
| hits | 0 | integer4 | Count of fix calls which resulted in cache hits, that is page requests which were satisfied from cache. |
| hits_d | 0 | integer4 | Count of fix calls resulting in cache hits in the last interval. |
| iowait | 0 | integer4 | Count of stalls waiting for I/O completion. |
| iowait_d | 0 | integer4 | Count of waits for io completion in the last interval. |
| single_reads | 0 | integer4 | Count of single page buffer reads. |
| single_reads_d | 0 | integer4 | Count of single page read operations in the last interval. |
| refresh | 0 | integer4 | Count of invalid page buffers refreshed. |
| refresh_d | 0 | integer4 | Count of pages refreshed in the last interval. |
| sbufcnt | 0 | integer4 | Count of single page buffers. |
| sbufcnt_d | 0 | integer4 | |
| status | 0 | integer4 | Numeric buffer manager status. |
| syncwr | 0 | integer4 | Count of single page buffers synched with the database. |
| syncwr_d | 0 | integer4 | Count of page synch write operations in the last interval. |
| unfix_calls | 0 | integer4 | Count of unfix calls. |
| unfix_calls_d | 0 | integer4 | |
| single_writes | 0 | integer4 | Count of single page buffer writes. |
| single_writes_d | 0 | integer4 | Count of single page write operations in the last interval. |
