RE: ODBC connection - extra statements being run

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Thu, 9 Feb 2006 12:22:09 -0600
Message-ID: <FB5D3CCFCECC2948B5DCF4CABDBE6697545DAB@QTEX1.qg.com>

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-----
	From: oracle-l-bounce_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Fedock, John
(KAM.RHQ)

	Sent: Thursday, February 09, 2006 11:24 AM
	To: oracle-l_at_freelists.org; oracledba_at_LazyDBA.com
	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.          

        Thanks.                              

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


[mailto:bruce.mccartney_at_dbinfosystems.com]

		Sent: Wednesday, February 08, 2006 5:02 PM
		To: Fedock, John (KAM.RHQ); oracle-l_at_freelists.org;
oracledba_at_LazyDBA.com
		Subject: RE: ODBC connection - extra statements being

run                                  

		John,
		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
		To: oracle-l_at_freelists.org; oracledba_at_LazyDBA.com
		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> us.kline.com 

--
http://www.freelists.org/webpage/oracle-l

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