Includes one row for each procedure cache allocator. An allocator is identified by an allocator ID, which is internal to Adaptive Server.
You need not enable any configuration parameters for this monitoring table to collect data.
The columns for monProcedureCacheMemoryUsage are:
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
InstanceID |
tinyint |
(Cluster environments only) ID of an instance in a shared-disk cluster. |
|
AllocatorID |
int |
Allocator ID |
|
ModuleID |
int |
Module ID (internal to Adaptive Server) |
|
Active |
int |
Number of memory pages (2KB) currently allocated to this allocator |
|
HWM |
int |
Maximum number of memory pages allocated since the server was started |
|
ChunkHWM |
int |
Largest number of contiguous memory pages allocated since the server was started |
|
AllocatorName |
varchar(30) |
Name of the allocator |
|
NumReuseCaused |
int |
Null |
Number of times this allocator has caused replacement |
