Database Management Technology 
The dmf_cache_stats table contains data page cache statistics for a specific database server. 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 | Cache page size in bytes. |
| checks | 0 | integer4 | Count of page check operations performed by the database server, page checks determine if the page is still valid. |
| checks_d | 0 | integer4 | Count of page check operations in the last interval. |
| dirty | 0 | integer4 | Count of dirty pages unfixed by the database server since server startup. |
| dirty_d | 0 | integer4 | Count of pages modified in the last interval. |
| fcwait | 0 | integer4 | Count of cache waits caused by fast commit processing. |
| fcwait_d | 0 | integer4 | Count of fast commit waits in the last interval. |
| fix_calls | 0 | integer4 | Count of page fix calls issued by the database server since server startup, a fix call occurs whenever a running query refrences a database page. |
| fix_calls_d | 0 | integer4 | Count of page fix calls in the last interval. |
| force | 0 | integer4 | Count of modified pages forced to the database by the database server. |
| force_d | 0 | integer4 | Count of pages forced to disk in the last interval. |
| fwait | 0 | integer4 | Count of free buffer waits since database server startup. |
| fwait_d | 0 | integer4 | Count of free page waits in the last interval. |
| group_reads | 0 | integer4 | Count of group read (readahead) operations performed since database server startup. |
| group_reads_d | 0 | integer4 | Count of group read operations in the last interval. |
| gsyncwr | 0 | integer4 | Count of group writes to synch the cache with the database since database server startup. |
| gsyncwr_d | 0 | integer4 | Group synch write operations in the last interval. |
| gwait | 0 | integer4 | Count of stall operations caused by a lack of available group buffers. |
| gwait_d | 0 | integer4 | Group free buffer waits in the last interval. |
| group_writes | 0 | integer4 | Count of group write operations performed since database server startup. |
| group_writes_d | 0 | integer4 | Count of group write operations in the last interval. |
| hits | 0 | integer4 | Count of fix calls which resulted in cache hits, that is page requests satisfied from cache. |
| hits_d | 0 | integer4 | Count of cache hits in the last interval. |
| iowait | 0 | integer4 | Count of stalls caused by waits for I/O completion. |
| iowait_d | 0 | integer4 | Count of io requests waiting for completion in the last interval. |
| single_reads | 0 | integer4 | Count of single page read operations since database server startup. |
| single_reads_d | 0 | integer4 | Count of single page read operations in the last interval. |
| refresh | 0 | integer4 | Count of invalid cache pages refreshed from the database. |
| refresh_d | 0 | integer4 | Count of page refresh operations in the last interval. |
| syncwr | 0 | integer4 | Count of write operations to synch single page buffers 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 since database server startup, a page is unfixed when query manipulation is complete. |
| unfix_calls_d | 0 | integer4 | Count of page unfix operations in the last interval. |
| single_writes | 0 | integer4 | Count of single page write operations since database server startup. |
| single_writes_d | 0 | integer4 | Count of single page write operations in the last interval. |
