15.10 - ResUsageSpma Table Overview - Teradata Database

Teradata Database Resource Usage Macros and Tables

Product
Teradata Database
Release Number
15.10
Published
April 2016
Language
English (United States)
Last Update
2018-05-17
dita:mapPath
Resource_Usage_Macros_15_10.ditamap
dita:ditavalPath
ft:empty

The ResUsageSpma table includes resource usage data for available system-wide information.

You can use the ResUsageSpma table to identify node-level skew by comparing maximum CPU usage to the average CPU consumed across all nodes.

The ResUsageSpma table is similar to the ResUsageIpma table. For information on this table, see ResUsageIpma Table.

Teradata recommends that you use ResSpmaView to access the data rather than accessing the ResUsageSpma table directly. For more information, see Resource Usage Views.

Summary Mode is not applicable to the ResUsageSpma table.

This table is created as a MULTISET table. For more information, see Relational Primary Index.