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 - 11:23:33 CST