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@Hotsos To: <oracle-l@xxxxxxxxxxxxx> .com> cc: Sent by: Subject: RE: Anyone seen weblogic do this? oracle-l-bounce@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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Freeman Robert - IL Sent: Thursday, June 24, 2004 4:51 PM To: 'oracle-l@xxxxxxxxxxxxx' 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------