Note
This view is introduced since OceanBase Database V4.2.0.
Purpose
The GV$OB_THREAD view displays the status information about all threads in the observer process of each OBServer node. In user tenants, it shows the relevant threads of the current tenant.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the observer process. |
| SVR_PORT | NUMBER(38) | NO | The port number of the observer process. |
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant to which the thread belongs. The value is 500 for a process-level thread. |
| TID | NUMBER(38) | NO | The ID of the thread. |
| TNAME | VARCHAR2(16) | NO | The name of the thread. |
| STATUS | VARCHAR2(32) | NO | The status of the thread. Valid values:
|
| LATCH_WAIT | VARCHAR2(16) | NO | The address of the latch that the thread is waiting for. |
| LATCH_HOLD | VARCHAR2(256) | NO | The address of the latch held by the thread. Multiple latches may be held by the thread. |
| TRACE_ID | VARCHAR2(40) | NO | The ID of the trace that is being executed by the thread. |
| CGROUP_PATH | VARCHAR2(256) | NO | The path of the cgroup to which the thread belongs. This field is obtained from the CPU row of the /proc/observer-pid/task/tid/cgroup file. |
Sample query
To view the status of all threads in the observer process on each OBServer node in the user tenant, display the first two records.
obclient > SELECT * FROM SYS.GV$OB_THREAD WHERE ROWNUM <= 2;
The query result is as follows:
+----------------+----------+-----------+-------+-----------------+--------+------------+------------+------------------------------------+-------------+
| SVR_IP | SVR_PORT | TENANT_ID | TID | TNAME | STATUS | LATCH_WAIT | LATCH_HOLD | TRACE_ID | CGROUP_PATH |
+----------------+----------+-----------+-------+-----------------+--------+------------+------------+------------------------------------+-------------+
| xx.xx.xx.xx | 28824 | 1004 | 92964 | T1004_TTLTablet | Wait | NULL | NULL | Y70980BA1CCFB-00060E2D0E29CB5B-0-0 | NULL |
| xx.xx.xx.xx | 28824 | 1004 | 92832 | T1004_TTLManage | Wait | NULL | NULL | Y70980BA1CCFB-00060E2D0DF9CB5C-0-0 | NULL |
+----------------+----------+-----------+-------+-----------------+--------+------------+------------+------------------------------------+-------------+
2 rows in set