TASKGROUPSTATISTICS

Definition

The system table TASKGROUPSTATISTICS contains information about task groups and their resource usage since the last start of the database instance.

Structure

TASKGROUPSTATISTICS

TASKGROUPID

FIXED(10)

ID of the task group

TASKCLUSTER

CHAR(20)

Task cluster to which this task group belongs

TASKCOUNT

FIXED(10)

Number of tasks in this group

USEDRUNQUEUELENGTH

FIXED(10)

Number of tasks lined up for CPU assignment

MAXUSEDRUNQUEUELENGTH

FIXED(10)

Maximum number of tasks lined up for CPU assignment

IDLECOUNT

FIXED(20)

Number of time intervals in which the CPU was released

IDLETIME

FIXED(20)

Total time for which the CPU was released (µs)

IOWAITCOUNT

FIXED(20)

Number of time intervals in which waits for outstanding I/O operations occurred

IOWAITTIME

FIXED(20)

Total wait time for outstanding I/O operations (µs)

USEDSYSTEMTIME

FIXED(20)

Total CPU time used in system mode (µs)

USEDUSERTIME

FIXED(20)

Total CPU time used in user mode (µs)

See also:

TASKGROUPSTATISTICSRESET

Concepts of the Database System, Overview of Tasks, Task Switching