Database Management Technology

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

dmf_cache_prim

The dmf_cache table contains configuration and state statistics for individual page caches of the buffer manager.  This table returns one row for each enabled page size of the buffer manager.

 
Attribute Name Key Datatype Description
server 1 varchar(64) Database server name.
page_size 2 integer4 Cache page size in bytes.
buffer_count 0 integer4 Count of cache page buffers including single and read-ahead buffers.
free_limit 0 integer4 Minimum free list size, when the free page count drops below this value a modified page must be written to the database before a new page can be read in.
group_buffers 0 integer4 Count of read-ahead buffers.
group_size 0 integer4 Read-ahead buffer size in page units.
bucket_count 0 integer4 Count of dmf cache hash buckets.
modify_limit 0 integer4 Modified page high limit, when the modified page count exceeds this value modified pages are written to the database as soon as they are un-fixed.
wb_end 0 integer4 Write behind end limit, when the modified page count drops below this value write behind threads are de-activated.
wb_start 0 integer4 Write behind start limit, when the modified page count exceeds this value write behind threads are activated to write modified pages to the database.

 


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