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 sessionNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------java_max_sessionspace_size           integer     0java_soft_sessionspace_limit         integer     0license_max_sessions                 integer     0license_sessions_warning             integer     0session_cached_cursors               integer     100session_max_open_files               integer     10sessions                             integer     885shared_server_sessions               integer> show parameter processesNAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------aq_tm_processes                      integer     0db_writer_processes                  integer     1gcs_server_processes                 integer     0global_txn_processes                 integer     1job_queue_processes                  integer     100log_archive_max_processes            integer     6processes                            integer     800> alter system set processes=1500 scope=spfile; 执行后session会自动变化