Returns statistics relating to Adaptive Server procedure cache.
Enable the enable monitoring configuration parameter for this monitoring table to collect data.
The columns for monProcedureCache are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
Requests |
int |
Counter, reset |
Number of stored procedures requested |
Loads |
int |
Counter, reset |
Number of stored procedures loaded into cache |
Writes |
int |
Counter, reset |
Number of times a procedure was normalized and the tree written back to sysprocedures |
Stalls |
int |
Counter, reset |
Number of times a process had to wait for a free procedure cache buffer when installing a stored procedure into cache |
InstanceID |
int |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
