Oracle-L: RE: Database just stops

From: Stephane Paquette <stephane.paquette_at_standardlife.ca>
Date: Tue, 14 Oct 2003 13:09:41 -0800
Message-ID: <F001.005D315B.20031014130941@fatcity.com>

MessageIf 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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Stephane Paquette
INET: stephane.paquette_at_standardlife.ca

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 14 2003 - 16:09:41 CDT