Oracle常用Sql

1.查看数据库链接数

SELECT username, machine, program, status, COUNT (machine) AS numbers
FROM v$session
GROUP BY username, machine, program, status ORDER BY machine;