Re: Hung Oracle sessions

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

Article #77

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

#77

From: Eduardo Elgueta
Date: Sat, 04 Jul 1998 00:00

15 lines
1191 bytes

Move to MS.

Glen E. Siferd wrote:

> 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: <359DB5EC.8FC317E1@netscape.net>

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

References: <6n8dfu$1jo8@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,99d4291f0a974160
X-Google-Attributes: gid101d9a,public
From: Eduardo Elgueta <eelgueta@netscape.net>
Subject: Re: Hung Oracle sessions
Date: 1998/07/04
Message-ID: <359DB5EC.8FC317E1@netscape.net>
X-Deja-AN: 368590326
Content-Transfer-Encoding: 7bit
References: <6n8dfu$1jo8@forums.borland.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.intrabuilder.data.sql

Reply to Parent Message