Note
This view is available starting with V4.2.0.
Purpose
This view displays the status information of all threads in the observer process on each OBServer node. In the sys tenant, it displays the related threads for all tenants.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the observer process. |
| SVR_PORT | bigint(20) | NO | The port number of the observer process. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant to which the thread belongs. 500 indicates a process-level thread. |
| TID | bigint(20) | NO | The ID of the thread. |
| TNAME | varchar(16) | NO | The name of the thread. |
| STATUS | varchar(32) | NO | The status of the thread:
|
| LATCH_WAIT | varchar(16) | NO | The address that the thread is waiting for a latch. |
| LATCH_HOLD | varchar(256) | NO | The address that holds the latch (multiple addresses are allowed). |
| TRACE_ID | varchar(40) | NO | The ID of the trace that is being executed on the thread. |
| CGROUP_PATH | varchar(256) | NO | The path of the cgroup to which the thread belongs. This field is obtained from the CPU line in the /proc/observer-pid/task/tid/cgroup path. |
Sample query
In the sys tenant, query the status information of all threads in the observer process on each OBServer node and display the first two records.
obclient > SELECT * FROM oceanbase.GV$OB_THREAD LIMIT 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 | 2882 | 1004 | 121695 | T1004_TTLTablet | Wait | | | YB42AC1E87E6-00060C5DCDEFE9E5-0-0 | |
| xx.xx.xx.xx | 2882 | 1004 | 121689 | T1004_TTLManage | Wait | | | YB42AC1E87E6-00060C5DCDAFE4D5-0-0 | |
+----------------+----------+-----------+--------+-----------------+--------+------------+------------+-----------------------------------+-------------+
2 rows in set