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. Each allocation is for a cylinder size worth of data. 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. Each allocation is for a cylinder size worth of data. 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 |