查看oracle串連數和會話情況

標籤：word   process   tran   esc   ora   ssi   not   machine   sof   

select  b.MACHINE, b.PROGRAM , count(*) from v$process a, v$session b where a.ADDR = b.PADDR and  b.USERNAME is not null   group by  b.MACHINE  , b.PROGRAM order by count(*) desc

或者

查看session：
　　select * from v$session where username is not null
　　select username,count(username) from v$session where username is not null group by username
　　當前串連數：
　　select count(*) from v$process

查看oracle串連數和會話情況