process
Hi everyone,
My database is 10.2.0.5.0 standard edition having 4GB RAM.
yesterday my alert log file showing these messages and my database hang for a moment.
Tue May 15 05:36:40 2012
Process q002 died, see its trace file
Tue May 15 05:37:33 2012
ksvcreate: Process(q002) creation failed
Tue May 15 05:52:38 2012
Process q003 died, see its trace file
Tue May 15 05:52:38 2012
ksvcreate: Process(q003) creation failed
Tue May 15 05:53:48 2012
WARNING: inbound connection timed out (ORA-3136)
Tue May 15 06:00:07 2012
Process J001 died, see its trace file
Tue May 15 06:00:07 2012
kkjcre1p: unable to spawn jobq slave process
my parameters is:
job_queue_processes integer 10
processes integer 150
sessions integer 200.
plz help me
Best Regards
My database is 10.2.0.5.0 standard edition having 4GB RAM.
yesterday my alert log file showing these messages and my database hang for a moment.
Tue May 15 05:36:40 2012
Process q002 died, see its trace file
Tue May 15 05:37:33 2012
ksvcreate: Process(q002) creation failed
Tue May 15 05:52:38 2012
Process q003 died, see its trace file
Tue May 15 05:52:38 2012
ksvcreate: Process(q003) creation failed
Tue May 15 05:53:48 2012
WARNING: inbound connection timed out (ORA-3136)
Tue May 15 06:00:07 2012
Process J001 died, see its trace file
Tue May 15 06:00:07 2012
kkjcre1p: unable to spawn jobq slave process
my parameters is:
job_queue_processes integer 10
processes integer 150
sessions integer 200.
plz help me
Best Regards
0