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