Summary statistics of the procedure cache
(INSTANCEID, CACHENAME)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| CACHENAME | string(16) | Literal: "Procedure Cache"; created by Surveillance |
| REQUESTS | double | Number of requests |
| LOADS | double | Number of loads |
| WRITES | double | Number of writes |
| STALLS | double | Number of stalls |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| REQUESTS_DELTA | double | Delta number of requests |
| LOADS_DELTA | double | Delta number of loads |
| WRITES_DELTA | double | Delta number of writes |
| STALLS_DELTA | double | Delta number of stalls |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |