当前位置 博文首页 > LuciferLiu_DBA：Oracle关于process的相关语句-ORA-00020
ERROR:
ORA-00020: maximum number of processes (150) exceeded
?
[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.
关于调整process的相关命令：
--关闭所有用户连接进程
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;