--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会自动变化