zxhong

我思故我在

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]zxhong的公告

<div><B>个人简介</B></div> 网名：zxhong<br> QQ：2500149<br> E-mail：<a href='mailto:zxhzxm@21cn.com'>zxhzxm@21cn.com</a><br> 来自：广东深圳 <hr size='1' width='100%'> <script language=JavaScript src="http://laoan.com/counters/count.php?zxhong"></script> <script type="text/javascript"></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

[编辑]文章分类

[编辑]热点问题

资料与金钱

存档

在Oracle&SQL Server里查找Connection 数量收藏

for sql server 如下：

select nt_username,count(0) from sysprocesses
group by nt_username
order by count(0) desc

select hostname,count(0) from sysprocesses where loginame='mms'
group by hostname
order by count(0) desc

select convert(varchar,last_batch,111),count(0) from sysprocesses where loginame='mms'
group by convert(varchar,last_batch,111)
order by count(0) desc

select convert(varchar,last_batch,111),count(0) from sysprocesses
group by convert(varchar,last_batch,111)
order by count(0) desc

select * from sysprocesses where hostname='www'

生成杀连接的sql语句:
select 'kill '+convert(varchar,spid) from sysprocesses where hostname='www'

以上语句，可以查全部以及某个用户的连接数量。

以下for Oracle

set linesize 100;
column username format a15;
column machine format a30;
select count(*),username,machine,sysdate from v$session where username is not null group by username,machine;