Database Management Technology

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

qsf_rqp

The qsf_rqp table returns statistics on QSF pool repeat queries.  One row is returned for each pool resident repeat query for each database server in the current IMA management domain.  The usage delta column is the number of repeat query executions 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.
query_index 2 integer4 Internal index id for the repeat query.
query_name 0 varchar(64) Repeat query name, name is of the format <id1> <id2> <name>.
query_size 0 integer4 The amount of QSF pool space occupied by the repeat query.
query_dbix 0 integer4 Database id of the owner database.
usage_count 0 integer4 Execution count for the repeat query, the execution count is incremented whenever the query is executed.
usage_count_d 0 integer4 Change in the repeat query execution count in the last interval.

 


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