Data cache summary
(INSTANCEID, ROWID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| ROWID | long | Always has value: 1 |
| PHYSICALREADSWRAP | long | Internal-use column to ensure physical reads delta, and related derived columns, handle counter wrap properly; created by Surveillance |
| PHYSICALREADS | double | Number of physical reads, mod 2147483648 (due to counter wrap in ASE) |
| LOGICALREADSWRAP | long | Internal-use column to ensure logical reads delta, and related derived columns, handle counter wrap properly; created by Surveillance |
| LOGICALREADS | double | Number of logical reads, mod 2147483648 (due to counter wrap in ASE) |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| PHYSICALREADS_DELTA | double | Delta number of physical reads |
| LOGICALREADS_DELTA | double | Delta number of logical reads |
| LOGICALREADS_RATE | double | Number of logical reads per second, in interval |
| LOGICALREADS_RATE_AVG | double | Average number of logical reads per second, since collection started |
| LOGICALREADS_RATE_MAX | double | Maximum number of logical reads per second, since collection started |
| MISS_PCT | double | Data cache miss %, or how often logical reads required physical reads |
| MISS_PCT_AVG | double | Average data cache miss %, since collection started |
| MISS_PCT_MAX | double | Maximum data cache miss %, since collection started |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |