oracle单个用户最大连接数限制

项目经理反馈，现场已做了单个用户的最大连接数2000的限制，但数据库还是报无法连接，故障用户的连接数已3800多了。

查看日志报错如下

2023-07-20T13:07:57.794653+08:00
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
2023-07-20T13:08:16.882441+08:00
ORA-00020: maximum number of processes (5000) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
2023-07-20T13:08:57.846261+08:00
Process m001 submission failed with error = 20
Process m002 submission failed with error = 20
2023-07-20T13:09:15.712546+08:00
Process J000 submission failed with error = 20
2023-07-20T13:09:15.712780+08:00
kkjcre1p: unable to spawn jobq slave process
2023-07-20T13:09:15.712950+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_3577.trc:

2023-07-20T13:12:20.920401+08:00
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_cjq0_3577.trc:
2023-07-20T13:12:22.930463+08:00
ORA-00020: maximum number of processes (5000) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.
2023-07-20T13:12:58.049562+08:00
Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
Process m000 submission failed with error = 20
Process m000 submission failed with error = 20
2023-07-20T13:13:25.510459+08:00
ORA-00020: maximum number of processes (5000) exceeded
 ORA-20 errors will not be written to the alert log for
 the next minute. Please look at trace files to see all
 the ORA-20 errors.

故障用户的当前连接数已3880了

查看默认的PROFILE，SESSIONS_PER_USER也确实做了2000限制

处理办法：

1、SQL> alter system set resource_limit =TRUE;   --对资源类的参数限制必须启用该参数

       SQL> alter profile DEFAULT limit sessions_per_user 2000;     ---事先已执行过，可不执行

2、kill用户USR_LTWX的非活动session

3、持续观察，该用户最大连接数没超过2000，

4、让现场经理通知用户产品排查故障原因