could try setting the sqlnet.expire_time=5 (5 minutes). This may clean
up live connections if they are waiting on some event.
If the processes are Java processes you should make sure that the java
programs issue a stmt.close[]
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 Tue Oct 19 1999 - 06:07:12 CDT
