Note
This view is available starting with V5.0.1.
Overview
The GV$OB_TENANT_WORKER_GROUPS view displays the status of worker thread groups on all nodes of the current tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | Server IP Address |
| SVR_PORT | NUMBER(38) | NO | Server Port Number |
| TENANT_ID | NUMBER(38) | NO | Tenant ID |
| GROUP_ID | NUMBER(38) | NO | Resource Group ID |
| WORKERS_SIZE | NUMBER(38) | NO | Current Worker Threads |
| REQ_QUEUE_SIZE | NUMBER(38) | NO | Length of the normal request queue |
| RECV_REQ_CNT | NUMBER(38) | NO | Cumulative Number of Requests Received |
| DELETED | tinyint(4) | NO | Whether the resource group has been marked for deletion:
|
| TOKEN_CHANGE_TS | NUMBER(38) | NO | Timestamp of the last token change |
| THROTTLED_TIME_US | NUMBER(38) | NO | Cumulative Throttling Time, Unit: microseconds |
| IDLE_CNT | NUMBER(38) | NO | Number of Idle Worker Threads |
| LAST_NOT_EMPTY_TS | NUMBER(38) | NO | Timestamp of the last non-null value in the queue |
Sample query
You can query the status of each worker group on each node in the current tenant.
obclient(sys@oracle001)[SYS]> SELECT * FROM SYS.GV$OB_TENANT_WORKER_GROUPS;
The query result is as follows:
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
| SVR_IP | SVR_PORT | TENANT_ID | GROUP_ID | WORKERS_SIZE | REQ_QUEUE_SIZE | RECV_REQ_CNT | DELETED | TOKEN_CHANGE_TS | THROTTLED_TIME_US | IDLE_CNT | LAST_NOT_EMPTY_TS |
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
| 6.xx.xxx.xxx | 2882 | 1004 | 28 | 1 | 0 | 427 | 0 | 1782356685517227 | 34359743778 | 1 | 1782356732002016 |
| 6.xx.xxx.xxx | 2882 | 1004 | 18 | 1 | 0 | 125447 | 0 | 1782356708724369 | 0 | 1 | 1782356732002016 |
| 6.xx.xxx.xxx | 2882 | 1004 | 15 | 2 | 0 | 122 | 0 | 1782294217146336 | 0 | 2 | 1782356732002016 |
| 6.xx.xxx.xxx | 2882 | 1004 | 20 | 0 | 0 | 641 | 0 | 1782324063122271 | 0 | 0 | 1782324063122265 |
| 6.xx.xxx.xxx | 2882 | 1004 | 2 | 1 | 0 | 504392 | 0 | 1782293680533044 | 0 | 1 | 1782356732002016 |
+--------------+----------+-----------+----------+--------------+----------------+--------------+---------+------------------+-------------------+----------+-------------------+
5 rows in set