Re: the opposite of DCD (dead connection detection)??
Date: Thu, 10 Jan 2008 10:59:00 -0800 (PST)
On Jan 9, 11:14 am, bdbafh <bdb..._at_gmail.com> wrote:
> On Jan 9, 10:52 am, Ben <benal..._at_yahoo.com> wrote:
> > 10.2.0.2 AIX 5.2 64bit.
> > Idle connections are getting terminated in databases on one of our
> > servers. I've checked profiles and resource plans to see if any have a
> > limit on idle time and there are none. It was first noticed in an
> > application and I've since been testing scenarios using sqlplus and it
> > happens with sqlplus also. I also thought it was limited to
> > connections that were coming in from another server but that isn't the
> > case either.
> > Certain things that stand out. It doesn't happen if the connection is
> > for the sysdba user. It doesn't happen if the connection is a local
> > connection that doesn't have the @sid in the connection string.
> > Any thoughts?
> Is there a host-based firewall in use (meaning on the localhost)?
> Can you test out this for connection on the same subnet (that would
> not traverse a router) vs. connections from clients not on the same
> This sure smells like a network issue where (translated) connections
> are being timed out.
> Start working with the network techs to see if they have any ideas.
Just another little piece of info. I setup a cronjob to see how long the connections stay connected when they are idle, looks like approximately 12 hours. Received on Thu Jan 10 2008 - 12:59:00 CST