Re: the opposite of DCD (dead connection detection)??

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