解决“Process m001 died……”问题,设置Processes数
最近服务器经常down掉,不停的down,从alsertSid.log一查,有如下错误信息:
Process m001 died, see its trace file
Wed Sep 16 10:00:52 2009
ksvcreate: Process(m001) creation failed
原来是oracle进程数达到Processes上限了。在oracle中:sessions和processes的关系是:
sessions=1.1*processes + 5
这样,通过修改processes可以同时修改process和sessions的目的。
解决过程如下:
SQL> conn xxx/yyyy
已连接。
SQL> show parameter sessions;
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
logmnr_max_persistent_sessions integer 1
sessions integer 170
shared_server_sessions integer
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 150
SQL> alter system set processes=200 scope=spfile;
系统已更改。
SQL> shutdown immediate;
SQL> show parameter sessions;
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
logmnr_max_persistent_sessions integer 1
sessions integer 225
shared_server_sessions integer
SQL> show parameter processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
db_writer_processes integer 1
gcs_server_processes integer 0
job_queue_processes integer 10
log_archive_max_processes integer 2
processes integer 200
资料来自: