1.--查看不同用户的连接数
select username,count(username) from v$session where username is not null group by username;
2.找到用户之后再看这个具体的用户通过那个终端连过来的
select username,osuser,machine,terminal,program from v$session where username='TEST';
1.--查看不同用户的连接数
select username,count(username) from v$session where username is not null group by username;
2.找到用户之后再看这个具体的用户通过那个终端连过来的
select username,osuser,machine,terminal,program from v$session where username='TEST';