Includes one row for each procedure cache allocator. An allocator is identified by an allocator ID, which is internal to SAP ASE.
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 SAP ASE) |
|
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 |