Re: Why session not going away?

In article <8fpnu8$2pr$1_at_nnrp1.deja.com>,   ccao_at_my-deja.com wrote:
> Hi,
>
> I am using ODBC driver to connect to an Oracle database. I have seen
> several cases that when my program which initiated those connections
 has
> gone away, but the sessions are still in the database with objects
> locked. Then I cannot restart my program because of a deadlock. I
> wonder why those session did not die though the process that opened
 them
> had died. How can I avoid this?
>
> Thanks for any suggestions.
>
> Chuck
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Hi,
I'm not the expert here but you coud try the following: o increase the period of which the PMON process runs (that cleans up your system)
o make sure you commit before exitting
o use NOWAIT flag wherever possible.

Good luck
JC

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 16 2000 - 00:00:00 CDT