Oracle系统资源使用查询及大小调整

建议：若非系统资源紧张，切记操作

有时候由于大量用户访问Oracle，造成无法访问数据库资源，旨在增加Oracle数据库访问连接数

查询Oracle 用户连接数

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

select count(*) from v$session where status='ACTIVE';

查看系统资源

select resource_name, current_utilization, max_utilization, limit, round(max_utilization / limit * 100) || '%' rate from (select resource_name, current_utilization, max_utilization, to_number(initial_allocation) limit from v$resource_limit where resource_name in ('processes', 'sessions') and max_utilization > 0);

修改系统资源大小，然后重启数据库

alter system set processes=1000 scope=spfile;

alter system set sessions=1110 scope=spfile;