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 the current OBServer node. In the sys tenant, it displays the relevant threads of 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 tenant ID to which the thread belongs. 500 indicates a process-level thread. |
| TID | bigint(20) | NO | The thread ID. |
| TNAME | varchar(16) | NO | The thread name. |
| STATUS | varchar(32) | NO | The thread status:
|
| LATCH_WAIT | varchar(16) | NO | The address being waited for by the latch. |
| LATCH_HOLD | varchar(256) | NO | The address holding the latch (can contain multiple addresses). |
| TRACE_ID | varchar(40) | NO | The ID of the trace being executed by 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 the current OBServer node and display the first two records.
obclient > SELECT * FROM oceanbase.V$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