Hung Oracle sessions

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

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Glen E. Siferd Mon, 29 Jun 1998 00:00

#76

Author: 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?

Re: Hung Oracle sessions

#77

Author: 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?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads