Hung Oracle sessions

Article View: borland.public.intrabuilder.data.sql

Article #76

Back to borland.public.intrabuilder.data.sql Previous Next

#76

From: Glen E. Siferd
Date: Mon, 29 Jun 1998 00:00

11 lines
1050 bytes

Our IB application runs a stored procedure in an Oracle package that
contains a moderately complex query.  We are experiencing frequent "hung"
sessions.  That is, the procedure is run and returns a "successful" status
code; but when the procedure is run again, no result or code is returned and
an Oracle session remains behind and is not cleaned up until overnight
maintenance processes are run.  Seems like the procedure should either run
and be complete, or fail and be complete, but this doesn't seem to be the
case.

Would anyone out there have any insight into this phenomenon?

Technical Details

Message-ID: <6n8dfu$1jo8@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,99d4291f0a974160,start
X-Google-Attributes: gid101d9a,public
From: "Glen E. Siferd" <siferd@infosys.uwex.edu>
Subject: Hung Oracle sessions
Date: 1998/06/29
Message-ID: <6n8dfu$1jo8@forums.borland.com>
X-Deja-AN: 367127163
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.intrabuilder.data.sql