Xref: alice comp.databases.oracle.misc:35539
Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!logbridge.uoregon.edu!msunews!not-for-mail
From: "Chris Weiss" <weisschr@pilot.msu.edu>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Impossible Deadlocks
Date: Wed, 7 Jul 1999 11:39:21 -0400
Organization: Michigan State University
Lines: 33
Message-ID: <7lvsbv$337$1@msunews.cl.msu.edu>
References: <7lucb7$vf4$1@nnrp1.deja.com>
X-AUTHid: weisschr
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

> These transactions normaly take a fraction of a second to perform but
> eventually the application hangs for an infinite time (at least about
> an hour). So it looks like a dead lock but I was told that deadlocks
> are solved by oracle imidiatly. But if it is not a deadlock then at
> least one instance of the application should keep running.

Have your DBA check the alert log.  If you have a conflict such as a
checkpoint error or log contention, sessions can hang even though the
deadlock within Oracle has been resolved.

You might also be losing your session, and your application might be hung
waiting for a response on a dead socket.  You might want to institute a
process that has a timeout.  After a timeout has occured, reconnect and
resubmit the transaction.

If this is happening on multiple session (everybody hangs at once), you have
a more serious problem.  My guess would be a flaky listener on the database.
If it is only individual sessions, then I would begin with what I have
suggested above.

> By the way. Can anybody tell me how to access this newsgroup with a
> normal News reader? I'm experiencing some problems with dejanews and
> would like to switch to my preferred newsreader but I don't know a
> newsserver which supports this group.

Try outlook express.  However, you must have direct access to a news server.

Chris Weiss
Compuware Corporation
Professional Services Division