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