RE: ODBC connection - extra statements being run
- From: "Jesse, Rich" <Rich.Jesse@xxxxxxxxxxxxxxxxx>
- To: <John.Fedock@xxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 9 Feb 2006 12:22:09 -0600
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Fedock, John
(KAM.RHQ)
Sent: Thursday, February 09, 2006 11:24 AM
To: oracle-l@xxxxxxxxxxxxx; oracledba@xxxxxxxxxxx
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@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:
