AMPUsageV[X] - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

Category: Integrity

Database: DBC

View Column Data Type Format Description
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) The name of a user.
CpuTime FLOAT NOT NULL ---,---,---,--9.99 The number of seconds of AMP insert CPU time used by the user and account.
DiskIO FLOAT NOT NULL ---,---,---,--9 The total number of reads and writes to disk by each AMP in the system (or the total for all AMPs if the sum aggregate is specified).
CpuTimeNorm FLOAT NOT NULL ---,---,---,--9.99 The normalized AMP CPU time used by the user and account.
Vproc SMALLINT NOT NULL -(5)9 The virtual processor for which an event was logged.
VprocType CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) The type of Vproc for which an event was logged.
Model CHAR(4) LATIN NOT CASESPECIFIC NOT NULL X(4) The PMA (Processor Module Assembly) model information for the Vproc for which an event was logged.