Returns statistics relating to Adaptive Server procedure cache.
Enable the enable monitoring configuration
parameter for this monitoring table to collect data.
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 |
