Re: Disconnect problem (process still alive)

There is a bug in version 8.0.5.0.0 that occurs with distributed transactions containing PL/SQL commits. (See GSX Problem - Solution No: 1011386.6 and Note:62301.1 (search metalink for error code 18208)).

Look to see if the serial numbers in v$session are incrementing for any of the sessions. If so, you'll probably get an ora-30 if you try to kill the session from OEM, Server Manager or the command line. I was able to eliminate the problem by installing patch set 8.0.5.1.0.

Good luck!

Carl DiPasquale
Oracle DBA
Visteon Corporation

CRAY_k wrote:

> We have Ora8 Server, when our application makes disconnect, on v$sessions it
> is ok, sqlnet connection has been clean, but there is still the process (we
> see it with Ora enterprise manager)
> ans after many hours, (ou application makes sevaral
> connection/disconnection) we have an ORA-0020 !!! max processes !!
>
> An idea ?
> Thanks
Received on Wed Nov 24 1999 - 21:01:19 CST