Process died -- no info in trace files

From: Saad Khan <saad4u_at_gmail.com>
Date: Wed, 15 Apr 2009 15:09:54 -0400
Message-ID: <76b3d4e30904151209r5c73821bg1d840632b64b61b9_at_mail.gmail.com>

Hi fellows,

I've oracle 10g (10.2.0.4) running at Linux with partitioning option. The users were running pipelines while I was informed that the they got crashed. When I checked the alert log file, I could see the following error messages:

*Wed Apr 15 14:03:54 2009

Process P003 died, see its trace file
Wed Apr 15 14:03:55 2009
Process P004 died, see its trace file
Wed Apr 15 14:03:56 2009

Process P003 died, see its trace file
Process P003 died, see its trace file
Process P003 died, see its trace file
Process P003 died, see its trace file

Wed Apr 15 14:04:02 2009
Process P005 died, see its trace file
Process P005 died, see its trace file

*Now, the wierd thing is, I really dont see anything in the trace file that
could point anything that could have caused this.

I checked my parameters and found that the PROCESSES parameter was set to a very low value (i.e.150). Now I've increased it to 400 but this is just a shot in dark. I'm totally unsure if this could be the reason.

Can anyone please help me? Its quite urgent.

Thanks,

Khan.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 15 2009 - 14:09:54 CDT