Re: Why session not going away?

Hi
Possible reason was that your program had initiated a long transaction, so locks could be released only after rollback of that transaction. And try to set up network parameter SESSION_TIMEOUT (i am not sure about the name, see doc), so listener will see if your client crash.

Oleg Fedorenkov

<ccao_at_my-deja.com> wrote in message news:8fpnu8$2pr$1_at_nnrp1.deja.com...
> 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.
Received on Sun Jun 04 2000 - 00:00:00 CDT