Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

dmf_bm_stats

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.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.