15.10 - AMPUsageV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Integrity

DBC

 

View Column

Data Type

Format

Source Table.Column

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Acctg.AccountName (Composite UPI)

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

Acctg.UserName (Composite UPI)

CpuTime

FLOAT

NOT NULL

---,---,---,--9.99 (explicit)

Acctg.CPU

DiskIO

FLOAT

NOT NULL

--,---,---,--9 (explicit)

Acctg.IO

CpuTimeNorm

FLOAT

NOT NULL

---,---,---,--9.99 (explicit)

Acctg.CpuNorm

Vproc

SMALLINT

NOT NULL

-(5)9

Acctg.Vproc

VprocType

CHAR(4) LATIN

NOT CASESPECIFIC

NOT NULL

X(4)

Acctg.VprocType

Model

CHAR(4) LATIN

NOT CASESPECIFIC

NOT NULL

X(4)

Acctg.Model

CPUTimeNorm

The CpuNorm column contains the normalized CPU value and is calculated:

CPU x scaling factor

UserName

For this column, the SYSTEMUSERID is a system user name that tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.

The following SELECT statement displays, for a given account, total CPU time and total disk accesses for all AMPs:

==> SELECT AccountName,SUM(CPUTime),SUM(Diskio)
       FROM DBC.AMPusageV WHERE AccountName=’7654’
       GROUP BY AccountName; 

 

Result:

AccountName     ­Sum(CPUTime)      Sum(DiskIO)
-----------     ------------      -------------
7654            204,352.88        5,226,742

For more information about how to control access, space, and ownership, see Database Design.