Database Management Technology

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

qsf_pool

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.  Delta columns represent counter changes in the last interval.

 
Attribute Name Key Datatype Description
timestamp 0 date Date and time the data was collected
delta_seconds 0 integer4 Elapsed time (seconds) since the previous refresh.
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.
memofy_left_d 0 integer4
memory_total 0 integer4 Total pool size in bytes.
percent_used 0 float4
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_objects_d 0 integer4
max_sessions 0 integer4 Highwater mark for sessions with pool objects.
max_sessions_d 0 integer4
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.
named_objs_d 0 integer4
unnamed_objs 0 integer4 Current count of un-named pool objects.
unnamed_objs_d 0 integer4
total_objs 0 integer4 Current object count.
total_objs_d 0 integer4
session_count 0 integer4 Number of sessions currently active.
session_count_d 0 integer4

 


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