Oracle关于process的相关语句-ORA-00020

[oracle ~]$ oerr ora 00020 
00020, 00000, "maximum number of processes (%s) exceeded"
// *Cause:  All process state objects are in use.
// *Action: Increase the value of the PROCESSES initialization parameter.

--关闭所有用户连接进程
ps -ef | grep LOCAL=NO | egrep -v "grep" | awk '{print "kill -9 "$2}' 

--查看ORACLE最大进程数：
select count(*) from v$session;
Select count(*) from v$session where status='ACTIVE';
show parameter processes;
alter system set processes = 2000 scope = spfile;

--查看当前有哪些用户正在使用数据
SELECT osuser, a.username,cpu_time/executions/1000000||'s', sql_fulltext,machine 
from v$session a, v$sqlarea b
where a.sql_address =b.address order by cpu_time/executions desc;

--记录的是数据库会话曾经达到的最大值
select sessions_highwater  from v$license;

--查询数据库自启动以来最大的并发数量
select * from v$license;