The dmf_cache_stats table contains data page cache statistics accumulated for all attached database servers. One row is returned for each enabled page size.
| Attribute Name | Key | Datatype | Description |
| 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. |
| clock | 0 | integer4 | |
| dirty | 0 | integer4 | Count of dirty (modified) pages unfixed. |
| single_free | 0 | integer4 | Current count of free single page buffers. |
| single_fixed | 0 | integer4 | Count of single page buffers currently fixed. |
| single_modified | 0 | integer4 | Current count of modified single page buffers. |
| fcwait | 0 | integer4 | Count of page waits caused by fast commit processing. |
| fix_calls | 0 | integer4 | Count of page fix operations, a fix occurs whenever a page is referenced by a running query. |
| force | 0 | integer4 | Count of modified pages forced to the database. |
| fwait | 0 | integer4 | Count of free buffer waits. |
| group_free | 0 | integer4 | Count of group buffers currently free. |
| group_fixed | 0 | integer4 | Count of group buffers currently fixed. |
| group_modified | 0 | integer4 | Count of group buffers currently modified. |
| group_reads | 0 | integer4 | Count of group read (readahead) operations performed. |
| gsyncwr | 0 | integer4 | Count of group buffer synch operations. |
| gwait | 0 | integer4 | Count of group buffer stalls, a stall occurs where there are no available group buffers. |
| group_writes | 0 | integer4 | Count of group writes operations performed. |
| hits | 0 | integer4 | Count of fix calls which resulted in cache hits, that is page requests which were satisfied from cache. |
| iowait | 0 | integer4 | Count of stalls waiting for I/O completion. |
| single_reads | 0 | integer4 | Count of single page buffer reads. |
| refresh | 0 | integer4 | Count of invalid page buffers refreshed. |
| sbufcnt | 0 | integer4 | Count of single page buffers. |
| status | 0 | integer4 | Numeric buffer manager status. |
| syncwr | 0 | integer4 | Count of single page buffers synched with the database. |
| unfix_calls | 0 | integer4 | Count of unfix calls. |
| single_writes | 0 | integer4 | Count of single page buffer writes. |