Database Management Technology

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

qsf_dbp_prim

The qsf_dbp_prim table returns statistics on QSF pool database procedures.  One row is returned for each pool resident procedure for each database server in the current IMA management domain.

 
Attribute Name Key Datatype Description
server 1 varchar(64) Database server name.
dbp_index 2 integer4 Internal index id for database procedure.
proc_name 0 varchar(64) Database procedure name, the name is of the form <id1> <id2> <name>.
proc_owner 0 varchar(32) Database procedure owner.
proc_size 0 integer4 The amount of QSF pool space occupied by the database procedure.
proc_dbid 0 integer4 Database id for the procedures owner database.
usage_count 0 integer4 Execution count for the database procedure, the count is incremented whenever the procedure executes.

 


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