The dmf_bm_stats table contains DMF buffer manager statistics. A buffer manager may be attached to multiple database servers and may contain multiple page sizes. This table returns one row per buffer manager. Delta columns represent the change in counter values since the previous 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. |
| bmcwait | 0 | integer4 | Count of waits for database or table cache entries. |
| bmcwait_d | 0 | integer4 | Count of waits for database of cache table entries in the last interval. |
| cpcheck | 0 | integer4 | Number of fast commit threads finished with consistency point. |
| cpcheck_d | 0 | integer4 | Count of fast commit threads finished with CP processing in the last interval. |
| cp_count | 0 | integer4 | Count of consistency points performed. |
| cp_count_d | 0 | integer4 | Count of consistency points completed in the last interval. |
| cp_index | 0 | integer4 | Current consistency point buffer id. |
| fc_flushes | 0 | integer4 | Count of fast commit flush operations. |
| fc_flushes_d | 0 | integer4 | Count of fast commit flush operations performed in the last interval. |
| lockreclaim | 0 | integer4 | Count of cache lock reclaims. |
| lockreclaim_d | 0 | integer4 | Count of cache lock reclaims in the last interval. |
| mwait | 0 | integer4 | Count of cache mutex waits. |
| mwait_d | 0 | integer4 | Count of cache mutex waits in the last interval. |
| server_count | 0 | integer4 | Count of servers connected to buffer manager. |
| server_count_d | 0 | integer4 | Change in server count connected to the buffer manager in the last interval. |
| status | 0 | integer4 | Buffer manager status mask, 0x0001 BMCB_WBWAIT, 0x002 BMCB_FCFLUSH, 0x004 BMCB_SHARED_BUFMGR, 0x0008 BMCB_PASS_ABORT, 0x0010 BMCB_PREPASS_ABORT, 0x0020 BMCB_IOMASTER, 0x0040 BMCB_DMCM |
| wb_flushes | 0 | integer4 | Count of write behind flush operations performed. |
| wb_flushes_d | 0 | integer4 | Count of write behind flush operations performed in the last interval. |
| db_cache | 0 | integer4 | Number of entries in the database cache list. |
| table_cache | 0 | integer4 | Number of entries in the table cache list. |