gbase8s有命令查看运行的线程状态、运行的sql？

学习学习

不清楚呢。

onstat -g sql：查看正在执行的 SQL 查询的信息
onstat -g ses：查看当前数据库会话的信息

onstat -g ath

Your evaluation license will expire on 2026-11-05 00:00:00
On-Line -- Up 00:03:15 -- 539456 Kbytes

Threads:
tid tcb rstcb prty status vp-class name
2 4de1d028 0 1 IO Idle 3lio* lio vp 0
3 4de35378 0 1 IO Idle 4pio* pio vp 0
4 4de56378 0 1 IO Idle 5aio* aio vp 0
5 4de77378 2354bc0 1 IO Idle 6msc* msc vp 0
6 4dea8378 0 1 IO Idle 7fifo* fifo vp 0
7 4dfa2d40 4be67028 3 sleeping secs: 1 11cpu main_loop()
8 4dea88b0 0 1 running 39soc* soctcppoll
9 4dec9998 0 1 cond wait arrived 40soc* soctcppoll
10 4de1d758 0 2 sleeping forever 41soc* soctcplst


onstat -g ath | grep sqlexec
Your evaluation license will expire on 2026-11-05 00:00:00
146 b6fb50d0 b3426f28 1 cond wait netnorm 1cpu sqlexec
147 b7055958 b3430ca8 1 cond wait netnorm 1cpu sqlexec


onstat -g sql
Your evaluation license will expire on 2026-11-05 00:00:00
On-Line -- Up 18:51:12 -- 8575984 Kbytes

onstat -g sql
Sess SQL Current Iso Lock SQL ISAM F.E.
Id Stmt type Database Lvl Mode ERR ERR Vers Explain
94 - sysmaster CR Not Wait 0 0 9.28 Off
93 - sysmaster CR Not Wait 0 0 9.28 Off

学习中，还不清楚。