Data cache buffer pools
(INSTANCEID, CACHEID, IOBUFFERSIZE)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| CACHEID | long | |
| IOBUFFERSIZE | long | |
| INSTANCECOUNT | long | |
| USEDPCT | double | |
| USEDBYTES | double | |
| ALLOCATEDKB | double | |
| PHYSICALREADS | double | |
| STALLS | double | |
| PAGESTOUCHED | double | |
| PAGESREAD | double | |
| BYTESREAD | double | |
| BUFFERSTOMRU | double | |
| BYTESTOMRU | double | |
| BUFFERSTOLRU | double | |
| BYTESTOLRU | double | |
| CACHENAME | string(32) | |
| TSYNC | long | |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| PHYSICALREADS_DELTA | double | |
| PHYSICALREADS_RATE | double | |
| STALLS_DELTA | double | |
| STALLS_OVERALL | double | |
| PAGESTOUCHED_DELTA | double | |
| PAGESREAD_DELTA | double | |
| PAGESREAD_RATE | double | |
| BUFFERSTOMRU_DELTA | double | |
| BUFFERSTOMRU_RATE | double | |
| BUFFERSTOLRU_DELTA | double | |
| BUFFERSTOLRU_RATE | double | |
| ALLOCATEDBYTES | double | |
| BYTESREAD_DELTA | double | |
| BYTESREAD_RATE | double | |
| BYTESTOMRU_DELTA | double | |
| BYTESTOMRU_RATE | double | |
| BYTESTOLRU_DELTA | double | |
| BYTESTOLRU_RATE | double | |
| USEDPCT_AVG | double | |
| USEDPCT_MAX | double |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 12.5.0.3 |