Re: Orphan sessions
From: <phil_herring_at_yahoo.com.au>
Date: Wed, 22 Jun 2011 16:18:23 -0700 (PDT)
Message-ID: <64866717-3087-4efb-b534-37678598c178_at_o10g2000prn.googlegroups.com>
On Jun 23, 3:33 am, David Budac <davidbu..._at_gmail.com> wrote:
> I guess I have to figure out why SQLNET.EXPIRE_TIME didn't work. We've
> had this parameter set. The more I read about it, the more I see it
> was supposed to work. The protocol in use is TCP which makes it even
> weirder.
Date: Wed, 22 Jun 2011 16:18:23 -0700 (PDT)
Message-ID: <64866717-3087-4efb-b534-37678598c178_at_o10g2000prn.googlegroups.com>
On Jun 23, 3:33 am, David Budac <davidbu..._at_gmail.com> wrote:
> I guess I have to figure out why SQLNET.EXPIRE_TIME didn't work. We've
> had this parameter set. The more I read about it, the more I see it
> was supposed to work. The protocol in use is TCP which makes it even
> weirder.
There's a known issue with Windows and DCD. Resolution depends on your version of Windows and is too gruesome to spell out here. Google "sqlnet.expire_time +keepalive" for the details.
- Phil