select program,machine,count(*) from v$session group by program,machine; 转载于:https://www.cnblogs.com/gentlewolf/archive/2007/04/20/721678.html