Database Management Technology

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

dmf_cache_stats_prim

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.

 


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