RE: Anyone seen weblogic do this?

From: <Rajesh.Rao_at_jpmchase.com>
Date: Thu, 24 Jun 2004 22:01:43 -0400
Message-ID: <OFCDF1C074.3AE0E1A9-ON85256EBE.000AE0DA-85256EBE.000B24FC@chase.com>

Yup. I have been there too. Select count(*) from dual; is a regular in our statspack reports. And I was told by the BEA guys, that this is done by weblogic to check if the connection is active or not. If the query fails, then they open another connection, to keep the weblogic connection pools at a steady number, specified in the config files.

Regards
Raj

                                                                                                                        
                    "Larry Klein"                                                                                       
                    <Larry.Klein_at_Hotsos       To:     <oracle-l_at_freelists.org>                                          
                    .com>                     cc:                                                                       
                    Sent by:                  Subject:     RE: Anyone seen weblogic do this?                            
                    oracle-l-bounce_at_fre                                                                                 
                    elists.org                                                                                          
                                                                                                                        
                                                                                                                        
                    06/24/2004 09:46 PM                                                                                 
                    Please respond to                                                                                   
                    oracle-l

A client of mine recently experienced a similar phemonemon, whereby for them
Weblogic was generating hundreds per minute of "select count(*) from dual;" SQL statements against their Oracle database. It turns out there are Weblogic configuration options to "TestConnectionsUponReserve" and "TestConnectionsUponRelease" which they had unintentionally selected; these options cause the select count(*) to be specified against whatever table name (typically "dual") is specified elsewhere among these configuration options.

Hth...

Larry Klein
Hotsos Enterprises, Ltd.
http://www.hotsos.com
630-513-8010 (Chicago office)
630-240-1190 (cellphone)

Upcoming events:
- Performance Diagnosis (3 day class) starting on/in

     06/22 Pittsburgh, 07/20 Cleveland, 08/10 Boston
     09/14 San Francisco


- SQL Optimization (4 day class) starting on/in

     06/14 Chicago, 06/28 Denver,  07/26 WashDC
     08/16 Minneapolis, 09/20 TBA, 10/18 New Orleans
     11/08 Dallas, 12/13 Atlanta

- Hotsos Symposium 2005 on Oracle System Performance, Dallas, March 6-10

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Freeman Robert - IL
Sent: Thursday, June 24, 2004 4:51 PM
To: 'oracle-l_at_freelists.org'
Subject: Anyone seen weblogic do this?

Has anyone seen Weblogic make hundreds of calls to all_constraints..over a period of a few hours? I've got this re-occuring query that is making calls to all_constraints and I'm told that Weblogic is doing this.... anyone have any insight into this?

Robert

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 24 2004 - 20:58:41 CDT