Re: the opposite of DCD (dead connection detection)??
Date: Wed, 9 Jan 2008 07:59:02 -0800 (PST)
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?
also, I'm not using shared server, and it's not a RAC system. Received on Wed Jan 09 2008 - 09:59:02 CST