当前连接数,按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.