RE: Stuck session help

From: Wales, Stephen (RTSI) <Stephen.Wales_at_riotinto.com>
Date: Wed, 7 Apr 2004 16:34:21 -0600
Message-ID: <9ACD42A615C4F1419122D16AB1C718DE537874@rtsiexch00.kennecott.riotinto.org>

Is it possible that your archive destination is full or=20 some related hold like that has affected you, making your database stall while waiting for archive space to free?

Any clues in your alert log or relevant trace files?

(May seem like obvious questions, but since you didn't=20 mention it, I figured I'd ask....)

Steve

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Daniel Fink Sent: Wednesday, April 07, 2004 4:12 PM
To: oracle-l_at_freelists.org
Subject: Stuck session help

We've got an application that is having problems with the processing becoming 'stuck'. I'm now stuck trying to figure out why. The process is a series of inserts into several tables. Quite a few of the inserts succeed, eventually one of them sticks.

It sticks before the execute phase of the insert. It is not waiting on a lock (but blocking others). There is plenty of free space in the datafile.

Any clues? Ideas?

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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Apr 07 2004 - 17:31:00 CDT