Re: Client connections intermittently lost

I have seen these 'select x from dual' used by jboss connection pool to ensure connections are still active or not ... do you have a idle connection timeout that is causing these connection to die and jboss tries to re-create?

Raj

On Tue, Jun 19, 2012 at 3:34 PM, Guillermo Alan Bort <cicciuxdba_at_gmail.com> wrote:
> Hi,
>  today I have a strange one.
>
>  We’re seeing requests (can be any, but we’re seeing it from the “select 1
> from dual” jdbc validation request as well as from the application). It
> appears the initial requests goes out and then it’s followed by retransmits
> with increasingly amount of delay between retransmits (maxes out at 2
> minutes) for a total of 15 minutes (about 16 retransmits total). Then it
> looks like there is a reset and the request goes through creating a new tcp
> connection and username/password are sent and the connection is established
> and the request finished.
>
> The Oracle side is a set of six databases spread across a 6 node pure
> 11.2.0.3 (4 databases) and the other two databases are in a 3 node pure
> 10.2.0.5 RAC. Both are on RHEL 5.6
>
> I am at a loss as to even where to begin. We're talking to the tomcat guys
> to find out exactly what the configurations mean, but honestly I don't
> understand what this could be.
>
> Alan.-
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l