RE: Database just stops

[Smith, Ron L.]

Title: Message

Thanks for the replies.  The server admin fessed up and said he had bounced the server a few times to do some software installs.   Thanks! Ron -----Original Message----- From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 14, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: Database just stops If the archive destination is full then for sure the database will stop but it will not crash. It's probably a bug, you should probably go to 8.1.7.4.   Talking about database stop, I just did an audit at a client site, during my spare time. The top 3 SQL: The first one was run 20 times per second and has 1280 gets The second one was run 14 times per minute and each execution has 78091 gets The third one was run 1 per minute and each execution has 965637 gets.   The database was really stopped !!! Of course the application vendor was talking about adding more hardware ...   Stephane -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Oracle-L Sent: 14 octobre, 2003 16:40 To: Multiple recipients of list ORACLE-L Subject: Re: Database just stops When you mean by "stops" - do u mean you are not able to connect any more from sql*net ? or even the current sessions hang ?   Are you running this in archivelog mode ? Is it possible that the database is in archivelog more and the archiver is not running ?   Babu     ----- Original Message ----- From: Smith, Ron L. To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 14, 2003 3:14 PM Subject: Database just stops I have an Oracle 8.1.7.0 database running on an MS2000 server.  A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs.  Nothing in the Event logs.  It just stops.   When I restart the database it goes through crash recovery but comes up fine.   Anyone have any ideas?   Thanks! Ron Smith