Data cache activity
(INSTANCEID, CACHEID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| CACHEID | long | Data cache ID |
| RELAXEDREPLACEMENT | double | Whether cache is using relaxed replacement strategy; 1 = yes, 0 = no |
| BUFFERPOOLS | long | Number of buffer pools defined in the data cache |
| INSTANCECOUNT | long | Number of instances using the data cache, if Cluster Edition |
| USEDPCT | double | % of total allocated space that is used |
| USEDBYTES | double | Amount of space used, in bytes |
| ALLOCATEDBYTES | double | Total allocated size, in bytes |
| PAGESREAD | double | Total number of pages read |
| BYTESREAD | double | Total bytes read |
| CACHESEARCHES | double | Number of cache searches |
| PHYSICALREADS | double | Number of physical reads |
| LOGICALREADS | double | Number of logical reads |
| PHYSICALWRITES | double | Number of physical writes |
| STALLS | double | Number of times that I/O operations were delayed because no clean buffers were available in the wash area |
| CACHEPARTITIONS | long | Number of partitions in the data cache |
| CACHENAME | string(32) | Data cache name |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| 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 |
| PHYSICALWRITES_DELTA | double | Delta number of physical writes |
| PHYSICALWRITES_RATE | double | Number of physical writes per second, in interval |
| PHYSICALWRITES_RATE_AVG | double | Average number of physical writes per second, since collection started |
| PHYSICALWRITES_RATE_MAX | double | Maximum number of physical writes per second, since collection started |
| PHYSICALREADS_DELTA | double | Delta number of physical reads |
| PHYSICALREADS_RATE | double | Number of physical reads per second, in interval |
| 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 |
| CACHESEARCHES_DELTA | double | Delta number of cache searches |
| STALLS_DELTA | double | Delta number of stalls |
| LOGICALREADS_OVERALL | double | Total number of logical reads, since collection started |
| PHYSICALREADS_OVERALL | double | Total number of physical reads, since collection started |
| PHYSICALWRITES_OVERALL | double | Total number of physical writes, since collection started |
| CACHESEARCHES_OVERALL | double | Total number of cache searches, since collection started |
| STALLS_OVERALL | double | Total number of stalls, since collection started |
| BYTESREAD_DELTA | double | Delta bytes read |
| BYTESREAD_RATE | double | Bytes read per second, in interval |
| USEDPCT_AVG | double | Average % of total allocated space that is used, since collection started |
| USEDPCT_MAX | double | Maximum % of total allocated space that is used, since collection started |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |