Re: Orphan sessions

From: Mladen Gogala <no_at_email.here.invalid>
Date: Wed, 22 Jun 2011 16:33:03 +0000 (UTC)
Message-ID: <pan.2011.06.22.16.33.03_at_email.here.invalid>

On Wed, 22 Jun 2011 07:00:48 -0700, David Budac wrote:

> hey are still there, orphaned, holding their resources. Which is
> perfectly fine, in my understanding of how Oracle handles it - the
> client is responsible for closing them. I'm just looking for a way of
> getting rid of them or at least identifying them automatically. It's
> something that very very rarely happens and I'm trying to find a clean
> solution on the side of the database

The following SQLNET.ORA parameters may help you:

SQLNET.EXPIRE_TIME
SQLNET.SEND_TIMEOUT
SQLNET.SEND_TIMEOUT

They work well on Linux. Not sure about W2k3, though.

-- 
http://mgogala.freehostia.com

Received on Wed Jun 22 2011 - 11:33:03 CDT