Re: Client connections intermittently lost
Date: Tue, 19 Jun 2012 18:36:01 -0300
Message-ID: <CAJ2dSGSdmEmwvYATSwqy3rOB+rP=TGm7dxBLhDDrhQgz6AcXeQ_at_mail.gmail.com>
It's tomcat, but it looks like it. However I don't understand why the session is timing out. Is it a tomact timeout? I have to resource plan in the database that would account for the timeout, and the app user profile is completely unlimited during testing phase (which is where we are). FW timeout is set to 5 hours, so that's not it. Hence my confusion. Thanks for the reply :)
Cheers
Alan.-
On Tue, Jun 19, 2012 at 5:13 PM, rjamya <rjamya_at_gmail.com> wrote:
> Alan,
>
> 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-lReceived on Tue Jun 19 2012 - 16:36:01 CDT