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
