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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------