RE: JBoss keeps sending select 'hello' from dual
Date: Thu, 23 Oct 2008 16:47:29 -0400
Message-ID: <304CF4722010DD4FA19829D09DDB956B01BDF160@prdhswsemlmb01.prod-am.ameritrade.com>
Never mind.
I tried some different search terms in Google after sending this out and think I've found the answer. Sorry about that.
Jay Miller
-----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 details on 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-l
Received on Thu Oct 23 2008 - 15:47:29 CDT