The system table TASKLOADBALANCINGTASKGROUPSTATES contains information about the task load balancing values of the individual task groups in the current measurement interval.
TASKLOADBALANCINGTASKGROUPSTATES
TASKGROUPID |
FIXED(10) |
ID of the task group |
MOVETASKTOTASKGROUPID |
FIXED(10) |
ID of the target task group to which a task of the task group (TASKGROUPID) is to be moved |
MOVEABLETASKCOUNT |
FIXED(10) |
Number of tasks in the task group that allow a task group move |
INTERVALSTARTTIME |
TIMESTAMP |
Start time of the current measurement interval |
TASKGROUPSLEEPTIME |
FIXED(20) |
Time (µs) within the measurement interval in which the task group was in sleep state (sleep on semaphore) |
TOTALTASKRUNNABLETIME |
FIXED(20) |
Total time (µs) within the measurement interval for which the tasks of the task group were runnable |
MAXTASKRUNNABLETIME |
FIXED(20) |
Maximum time (µs) within the measurement interval for which the tasks of the task group were runnable |
See also:
Concepts of the Database System, Overview of Tasks, Task Switching