Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

ODBC connection - extra statements being run

From: Fedock, John (KAM.RHQ) <John.Fedock_at_us.kline.com>
Date: Wed, 8 Feb 2006 15:46:48 -0500
Message-ID: <5042FDC675779848A113F70D54F587490E3BB74D@KAMRICEXCLUS.us.kline.com> 





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 Wed Feb 08 2006 - 14:46:48 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US