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|
|SpaceReactiveCnt||track||Number of AWTs waiting for space allocations as last tracked at the end of logging period.||FLOAT|
|SpaceReactiveWaitTime||count||Total time in milliseconds that different worker tasks were in reactive mode waiting on space allocations during the logging period.||FLOAT|