for sql server as follows: select nt_username, count (0) from sysprocesses group by nt_usernameorder by count (0) descselect hostname, count (0) from sysprocesses where loginame = 'mms'group by hostnameorder by count (0) descselect convert (varchar, last_batch, 111), count (0) from sysprocesses where loginame = 'mms' group by convert (varchar, last_batch, 111) order by count (0) descselect convert (varchar, last_batch, 111), count (0) from sysprocesses group by convert (varchar, last_batch, 111) order by count (0) descselect * from sysprocesses where hostname = 'www' generated kill sql statement connected to: select 'kill' convert (varchar, spid) from sysprocesses where hostname = 'www 'The above statement, you can check the number of connections to a certain user. The following for Oracle Set Linesize 100; Column UserName Format A15; Column Machine Format A30; Select Count (*), Username, Machine, Sysdate from V $ Session Where Username, Machine;
