Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ODBC connection - extra statements being run

RE: ODBC connection - extra statements being run

From: Jesse, Rich <>
Date: Thu, 9 Feb 2006 12:22:09 -0600
Message-ID: <>

Sorry to chime in late. We had this exact problem several times. As near as I can tell, it's a function of the version of MDAC (ODBC driver bloat pool). Make sure all interested parties use the same version of MDAC.   Also, with MS Axis of Evil (aka "MS Access"), the workaround was to reconnect all linked Oracle tables. This seemed to get Axis to think "Hey, maybe if I join these two tables instead of FTSing the both and then joining them, maybe it'll be faster!".  

HTH! GL!   Rich

	-----Original Message-----

[] On Behalf Of Fedock, John
	Sent: Thursday, February 09, 2006 11:24 AM
	Subject: RE: ODBC connection - extra statements being run
	Thanks for all the responses.  It seems a lot of others have had
issues out there as well. What happened to me was some were complaining about the excel reports running slow. They sent me the SQL statement and it ran for me in < 1 second. I watched them run it and it took about 10 minutes. I then traced it with a 10046 and I saw the expected SQL statement run and complete - then another 2 table select ran with no join or anything. The columns in the where clause involve dates and the tables themselves are large ( > 40,000,000 rows). I have spent about 4 hours on google, metalink and microsoft support site without any answers. If I find anything I will let you all know.          


		-----Original Message-----
		From: McCartney, Bruce

Sent: Wednesday, February 08, 2006 5:02 PM To: Fedock, John (KAM.RHQ);; Subject: RE: ODBC connection - extra statements being
		Some ODBC drivers execute extra statements to determine
data types of columns and what not. Which driver are you using? Try using a newer ODBC driver. Did you trace timed events in the 10046 trace? What is it waiting on?
		From: Fedock, John (KAM.RHQ)
		Sent: Wed 2/8/2006 1:46 PM
		Subject: ODBC connection - extra statements being run

		When a user connects to my HP-UX 10g database from Excel
via ODBC and runs a SQL select statement joining 2 tables, a 10046 trace clearly shows that statement running quickly, then another mysterious statement running, which is basically a select from the 2 tables with no join. This causes it to run for more than 10 minutes. The original statement runs < 2 second in SQLPLUS. Can anyone explain?

                Thanks all,

		John Fedock 
		K Line America, Inc. 
		john.fedock <at> 

Received on Thu Feb 09 2006 - 12:22:09 CST

Original text of this message