Database Management Technology

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

qsf_rqp_prim

The qsf_rqp_prim 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.

Attribute Name Key Datatype Description
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.

 


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