Database Management Technology

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

dmf_bm_stats_prim

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.

Attribute Name Key Datatype Description
server 1 varchar(64) Database server name.
bmcwait 0 integer4 Count of waits for database or table cache entries.
cpcheck 0 integer4 Number of fast commit threads finished with consistency point.
cp_count 0 integer4 Count of consistency points performed.
cp_index 0 integer4 Current consistency point buffer id.
fc_flushes 0 integer4 Count of fast commit flush operations.
lockreclaim 0 integer4 Count of cache lock reclaims.
mwait 0 integer4 Count of cache mutex waits.
server_count 0 integer4 Count of servers connected to buffer manager.
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.
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.