These columns identify the allocation statistics reported by the Allocator process.
| Column Name | Mode | Description | Data Type |
|---|---|---|---|
| ExtAllocHot | count | Number of hot allocations made in the current log period. A hot allocation is an allocation whose estimated temperature falls within the pre-defined hot temperature range. The cylinder resides in some disk storage location and holds some data. Temperature is the frequency of access to the data by I/O independent of where the data resides. |
FLOAT |
| ExtAllocNonPacing | count | Number of non-pacing allocations made in the current log period. A non-pacing allocation is an allocation whose data access affects neither system performance nor individual query performance. | FLOAT |
| ExtAllocStatic | count | Number of static allocations made in the current log period. A static allocation is an allocation whose requested temperature is used and the measured temperature is ignored during migration. | FLOAT |
| ExtAllocSystemPacing | count | Number of system pacing allocations made in the current log period. A system pacing allocation is an allocation whose data access affects system performance. | FLOAT |
| ExtAllocTotal | count | Total number of allocations made in the current log period. A number of computations can be derived. For example: Cold Allocation = ExtAllocTotal – ExtAllocHot – ExtAllocWarm QueryPacing Allocation = ExtAllocTotal – ExtAllocNonPacing – ExtAllocSystemPacing Dynamic Allocation = ExtAllocTotal - ExtAllocStatic |
FLOAT |
| ExtAllocWarm | count | Number of warm allocations made in the current log period. A warm allocation is an allocation whose estimated temperature falls within the pre-defined warm temperature range. The cylinder resides in some disk storage location and holds some data. Temperature is the frequency of access to the data by I/O independent of where the data resides. |
FLOAT |