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. For user tenants, it shows the relevant threads of the current tenant.
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. For process-level threads, the value is 500. |
| 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 (may contain multiple addresses). |
| TRACE_ID | varchar(40) | NO | The ID of the trace being executed on the thread. |
| CGROUP_PATH | varchar(256) | NO | The path of the cgroup to which the thread belongs. This field information is obtained from the CPU line under the /proc/observer-pid/task/tid/cgroup path. |
Sample query
For a user 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