Database Management Technology

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

qsf_pool_prim

The qsf_pool table contains QSF pool size and usage statistics.  One row is returned for each database server in the current IMA management domain.

 
Attribute Name Key Datatype Description
server 1 varchar(64) Database server name.
buckets_used 0 integer4 Count of hash buckets with at least one entry.
bucket_max_objs 0 integer4 Maximum number of objects in any hash bucket.
decay_factor 0 integer4 Object decay factor.
memory_left 0 integer4 Amount of un-allocated pool memory in bytes.
memory_total 0 integer4 Total pool size in bytes.
max_master_objs 0 integer4 Maximum number of master objects in the pool.
max_named_objs 0 integer4 Maximum number of named objects in the pool.
max_req_size 0 integer4 Largest pool memory request since server startup.
max_stored_size 0 integer4 Largest pool object since server startup.
max_unnamed_objs 0 integer4 Highwater mark for un-named pool objects.
max_buckets 0 integer4 Highwater mark for buckets with at least one object.
max_objects 0 integer4 Highwater mark for pool objects.
max_sessions 0 integer4 Highwater mark for sessions with pool objects.
named_requests 0 integer4 Count of named object requests.
bucket_count 0 integer4 Number of buckets in the repeat query hash table.
no_destroyed 0 integer4 Count of objects destroyed.
no_index 0 integer4 Current number of named objects.
named_objs 0 integer4 Current count of named pool objects.
unnamed_objs 0 integer4 Current count of un-named pool objects.
total_objs 0 integer4 Current object count.
session_count 0 integer4 Number of sessions currently active.

 


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