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' (全部详细信息)
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' (全部详细信息)