ksvcreate: Process(m000) creation failed

来源：互联网发布：win8 java 编辑：程序博客网时间：2024/06/05 00:48

oracle alter日志报

ksvcreate: Process(m000) creation failed
Wed Feb 27 17:16:38 2013
Process m000 died, see its trace file
Wed Feb 27 17:16:38 2013
ksvcreate: Process(m000) creation failed
Wed Feb 27 17:17:39 2013
Process m000 died, see its trace file
Wed Feb 27 17:17:39 2013
ksvcreate: Process(m000) creation failed

怀疑可能是连接数满的问题

SQL> show parameter process

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 500

SQL> select count(*) from v$session;

COUNT(*)
----------
488

由于以前一直没有出现过这个大的连接数，询问应用是否有什么改动，应用说改过程序，停掉增加的功能，连接降了下来，

不要连接满了就修改连接数，要知道什么导致这个高的连接，才是解决问题的最佳方式