17.05 - Space Accounting Columns for ResUsageSvpr Table - Teradata Database

Teradata Vantageā„¢ - Resource Usage Macros and Tables

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Administration
User Guide
featnum
B035-1099-170K

Previously, the Teradata Database accounting system assumed an even distribution of rows to AMPs. The database and user space limits were set at the AMP level to the defined maximum limit values divided by the number of AMPs in the system. Space was managed and monitored at the AMP level.

Some features now allow tables on subsets of AMPs. The space accounting and space management infrastructure now manages the space limits at a global or system level and augments the AMP-level space management. These enhancements are referred to as global space accounting.

These columns report statistics for space accounting.

Column Name Mode Description Data Type
SpaceProactiveAllocs count Total number of proactive allocations made in the AMP during the logging period. This field is populated by the spalocal task. FLOAT
SpaceGroupAllocs count Total number of group allocations initiated in the AMP during the logging period. This field is populated by the spaglobal task. FLOAT
SpaceMsgsCnt count Total number of allocations or de-allocation messages processed by the space accounting task managing the system limit for a database or user. This field is populated by the spaglobal task. FLOAT
SpaceAllocated count Total number of bytes of space allocated to the AMP. This field is populated by the spalocal task. FLOAT
SpaceDeallocated count Total number of bytes of space de-allocated from the AMP. This field is populated by the spalocal task. FLOAT