Re: oracle windows process crash

Install something like oracle os watcher ( runs on multiple operating systems ) and set it up to run every minute and keep the information for a week.
 
It collects information ( processes / memory / etc ) and puts that stuff into files.
 
You should get a much clearer picture of what is happening memory/programs up to the minute prior to things going south.  Is it just os related / pga related / sga related etc.  Slice and dice here. 
 
At prior job we had some funky things going on with apex on a system that was doing some of the automatic memory stuff ... might have to check carefully your settings in that area and turn off any auto sizing stuff and set appropriate ranges for shared_pool database buffers large_pool etc.
 
Some kind of sga monitoring is called for also probably.  
 

________________________________
 From: Jeff C <backseatdba_at_gmail.com>
To: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 
Sent: Thursday, November 14, 2013 5:44 PM
Subject: oracle windows process crash
  


Oracle on Windows here.  Has anybody experience the oracle.exe process just disappear and the Windows Service not running anymore?  This has happened 3 times on 2 different 10g XE instances.  There is not information in the alert log or the Windows Event Viewer.  What could I do to help troubleshoot this issue?  I am lost.

Thanks. 

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