Database Management Technology

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

qsf_dbp

The qsf_dbp 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.  The usage delta column is the number of procedure 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.
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.
usage_count_d 0 integer4 Change in the database procedure execution count in the last interval.

 


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