oracle中查看当前连接数

?

SELECT username, machine, program, status, COUNT(machine) AS 连接数量

? ? ? ? ? FROM v$session

? ? ? ? ?where machine = 'CSIXA-4343'

? ? ? ? ?GROUP BY username, machine, program, status

? ? ? ? ?ORDER BY machine

?

SELECT username, machine, program, status, COUNT(machine) AS 连接数量

? ? ? ? ? FROM v$session

? ? ? ? ?GROUP BY username, machine, program, status

? ? ? ? ?ORDER BY machine