The system table SYSINFO.TASKGROUPSTATISTICS contains information about task groups and their resource usage since the last start of the database instance.
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) |