Re: JBoss keeps sending select 'hello' from dual
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: Jay.Miller@xxxxxxxxxxxxxxxx
- Date: Thu, 23 Oct 2008 15:09:50 -0700
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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Jay.Miller@xxxxxxxxxxxxxxxx
> Sent: Thursday, October 23, 2008 4:34 PM
> To: oracle-l@xxxxxxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
