达梦数据库如何查询当前连接

当前连接数，按IP分组

SQL> select curr_sch,CLNT_IP,count(1) from v$sessions where CURR_SCH not in ('SYSDBA','ITSM','DBOPR') group by curr_sch,CLNT_IP order by 1,2;

LINEID curr_sch CLNT_IP COUNT(1) 

--------- -------- -------------------- --------------------

1 NTSICR ::ffff:10.132.40.220 30

2 NTSICR ::ffff:10.135.56.123 2

used time: 2.633(ms). Execute id is 1351115201.