一样的 SQL语句如下:SELECT username, machine, program, status, COUNT (machine) AS 连接数量 FROM v$session GROUP BY username, machine, program, status ORDER BY machine;
select username,machine,program,status,count(machine) from v$session group by username,machine,program,status order by username,machine
SQL语句如下:SELECT username, machine, program, status, COUNT (machine) AS
连接数量
FROM v$session
GROUP BY username, machine, program, status
ORDER BY machine;
from v$session
group by username,machine,program,status
order by username,machine