Re: JBoss keeps sending select 'hello' from dual

Don't keep us in suspense like that.

What was it?

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

On Thu, Oct 23, 2008 at 1:47 PM, <Jay.Miller_at_tdameritrade.com> wrote:

> 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
>
>
>

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