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. For user tenants, it also displays 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 ID of the tenant to which the thread belongs. For process-level threads, this value is 500. |
| TID | bigint(20) | NO | The thread ID. |
| TNAME | varchar(16) | NO | The name of the thread. |
| STATUS | varchar(32) | NO | The status of the thread. Valid values:
|
| LATCH_WAIT | varchar(16) | NO | The address of the latch that the thread is waiting for. |
| LATCH_HOLD | varchar(256) | NO | The address of the latch that the thread is holding. This field may contain multiple values. |
| 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
For a user 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