RE: JBoss keeps sending select 'hello' from dual
Date: Tue, 28 Oct 2008 15:17:04 -0400
Well, what we tried was swapping out
<check-valid-connection-sql >select 'hello' from dual
However that seems to generate an equal number of
select 'x' from dual
statements so I don't know that we've gained very much. Anyone have other suggestions?
Sr. Oracle DBA
From: Jared Still [mailto:jkstill_at_gmail.com]
Sent: Thursday, October 23, 2008 6:10 PM
To: Miller, Jay
Subject: Re: JBoss keeps sending select 'hello' from dual
Don't keep us in suspense like that.
What was it?
Certifiable Oracle DBA and Part Time Perl Evangelist
On Thu, Oct 23, 2008 at 1:47 PM, <Jay.Miller_at_tdameritrade.com> wrote:
I tried some different search terms in Google after sending this out and
think I've found the answer. Sorry about that.
-----Original Message----- From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jay.Miller_at_tdameritrade.com Sent: Thursday, October 23, 2008 4:34 PM To: oracle-l_at_freelists.org Subject: JBoss keeps sending select 'hello' from dual While investigating some performance issues on two unrelated databases one of the odd things we found was a huge number of "select 'hello' from dual" statements hitting the databases (as in over a million/hour). Further investigation leads us to believe that this is a standard feature of JBoss connection pooling and the method it uses to check if a connection is still alive but we couldn't find any real detailson it.
Just wondering if anyone else has encountered this before and can point
me to additional information or any way of reducing its impact.
Thanks, Jay Miller -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 28 2008 - 14:17:04 CDT