sql--查询数据库的连接数

Oracle:

select * from v$session (全部详细信息)

select username,count(username) from v$session where username is not null group by username (用户不为空的)


PostgreSQL:

select * from pg_stat_activity where client_addr='127.0.0.1' (全部详细信息)