v$process v$session

1.当前的数据库连接数

select count(*) from v$process

查看不同用户的连接数

select username,count(username) from v$session where username is not null group by username;
select username,status , count(username) from v$session where username is not null group by username ,status;
select username,status   from v$session  ;

查询oracle的并发连接数
select count(*) from v$session where status='ACTIVE';

2.数据库允许的最大连接数

select value from v$parameter where name = 'processes'

3.修改最大连接数

alter system set processes = 300 scope =spfile;

shutdown immediate;

startup;--重启数据库

 

5.查看当前有哪些用户正在使用数据

SELECT osuser, a.username,cpu_time/executions/1000000||'s', b.sql_text,machine
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc;

col machine for a15;
SELECT osuser, a.username , machine
from v$session a, v$sqlarea b
where a.sql_address =b.address