1
desc oceanbase.__all_virtual_thread;
2
Field Type Null Key Default Extra
3
svr_ip varchar(46) NO NULL
4
svr_port bigint(20) NO NULL
5
tenant_id bigint(20) NO NULL
7
tname varchar(16) NO NULL
8
status varchar(32) NO NULL
9
wait_event varchar(64) NO NULL
10
latch_wait varchar(16) NO NULL
11
latch_hold varchar(256) NO NULL
12
trace_id varchar(40) NO NULL
13
loop_ts timestamp(6) NO NULL
14
cgroup_path varchar(256) NO NULL
15
desc oceanbase.GV$OB_THREAD;
16
Field Type Null Key Default Extra
17
SVR_IP varchar(46) NO NULL
18
SVR_PORT bigint(20) NO NULL
19
TENANT_ID bigint(20) NO NULL
21
TNAME varchar(16) NO NULL
22
STATUS varchar(32) NO NULL
23
LATCH_WAIT varchar(16) NO NULL
24
LATCH_HOLD varchar(256) NO NULL
25
TRACE_ID varchar(40) NO NULL
26
CGROUP_PATH varchar(256) NO NULL
27
select count(1) from oceanbase.__all_virtual_thread where tname = "";
30
select count(1) from oceanbase.V$OB_THREAD where tname = "observer";