RE: ODBC connection - extra statements being run
- From: "Fedock, John (KAM.RHQ)" <John.Fedock@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>, <oracledba@xxxxxxxxxxx>
- Date: Thu, 9 Feb 2006 12:23:33 -0500
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@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, February 08, 2006 5:02 PM
To: Fedock, John (KAM.RHQ); oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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
Other related posts:
