java项目processes设置,processes参数设置

--oracle用户进程连接数

>ps -ef |grep oracles |wc -l

227

--该用户最大进程数

>lsattr -E -l sys0|grep maxuproc

maxuproc 2048 Maximum number of PROCESSES allowed per user True

--root执行修改

# chdev -l sys0 -a maxuproc=3800

> show parameter session

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

java_max_sessionspace_size integer 0

java_soft_sessionspace_limit integer 0

license_max_sessions integer 0

license_sessions_warning integer 0

session_cached_cursors integer 100

session_max_open_files integer 10

sessions integer 885

shared_server_sessions integer

> show parameter processes

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

aq_tm_processes integer 0

db_writer_processes integer 1

gcs_server_processes integer 0

global_txn_processes integer 1

job_queue_processes integer 100

log_archive_max_processes integer 6

processes integer 800

> alter system set processes=1500 scope=spfile;

执行后session会自动变化