Database Management Technology

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

dmf_server_stats_prim

The dmf_server_stats table contains data page cache statistics for a specific database server.  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 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.
dirty 0 integer4 Count of dirty pages unfixed by the database server since server startup.
fcwait 0 integer4 Count of cache waits caused by fast commit processing.
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.
force 0 integer4 Count of modified pages forced to the database by the database server.
fwait 0 integer4 Count of free buffer waits since database server startup.
group_reads 0 integer4 Count of group read (readahead) operations performed since database server startup.
gsyncwr 0 integer4 Count of group writes to synch the cache with the database since database server startup.
gwait 0 integer4 Count of stall operations caused by a lack of available group buffers.
group_writes 0 integer4 Count of group write operations performed since database server startup.
hits 0 integer4 Count of fix calls which resulted in cache hits, that is page requests satisfied from cache.
iowait 0 integer4 Count of stalls caused by waits for I/O completion.
single_reads 0 integer4 Count of single page read operations since database server startup.
refresh 0 integer4 Count of invalid cache pages refreshed from the database.
syncwr 0 integer4 Count of write operations to synch single page buffers with the database.
unfix_calls 0 integer4 Count of unfix calls since database server startup, a page is unfixed when query manipulation is complete.
single_writes 0 integer4 Count of single page write operations since database server startup.

 


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