17.00 - Process Scheduling: CPU Utilization Columns - Teradata Database

Teradata Vantage™ - Resource Usage Macros and Tables

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

These columns represent CPU activities associated with this virtual processor, subdivided into 48 partitions. Partition 0 is reserved for use by PDE processes. For more information on the other partitions see Partition Assignments Overview.

For definitions of user service and user execution, see “Process Scheduling Columns” in the ResUsageScpu Table Overview.

Column Name Mode Description Data Type
CPUUServPart00 -CPUUServPart48 count Time in centiseconds CPUs are busy in the partition doing user service. This is the system level time spent on a process. FLOAT
CPUUExecPart00 -CPUUExecPart48 count Time in centiseconds CPUs are busy in the partition doing user execution. This is the user level time spent on a process.
Some CPU times may not be reported to these fields if child processes or threads are running on your system. For information about the difference in CPU usage reported and possible cause, see Process Scheduling: CPU Utilization Columns in ResUsageSps table.
FLOAT