Re: ODBC & Hints
From: joel garry <joel-garry_at_home.com>
Date: Tue, 21 Feb 2012 08:49:16 -0800 (PST)
Message-ID: <8d2da933-cef2-4098-a082-c1954f4fe7af_at_i10g2000pbc.googlegroups.com>
On Feb 21, 8:03 am, Daria Wieczorek <daria.wieczo..._at_uni-giessen.de> wrote:
> Hi,
>
> are there any known issues re: passing hints (in this case LEADING) to
> the db server via odbc? My problem is that a query which runs OK via
> direct access (e.g. using the Golden32 tool) hangs when executed via
> odbc. Since the query uses the LEADING hint my suspicion is that the
> odbc "swallows" the hint, treating it as a comment.
>
> Database is 9.2.0.8, odbc is Oracle ODBC Driver, Release 11.2.0.1.0
>
> Of course it also could be that the *application* using the odbc is
> "swallowing" the hint, not the odbc itself.
>
> Any ideas?
>
> Daria
Date: Tue, 21 Feb 2012 08:49:16 -0800 (PST)
Message-ID: <8d2da933-cef2-4098-a082-c1954f4fe7af_at_i10g2000pbc.googlegroups.com>
On Feb 21, 8:03 am, Daria Wieczorek <daria.wieczo..._at_uni-giessen.de> wrote:
> Hi,
>
> are there any known issues re: passing hints (in this case LEADING) to
> the db server via odbc? My problem is that a query which runs OK via
> direct access (e.g. using the Golden32 tool) hangs when executed via
> odbc. Since the query uses the LEADING hint my suspicion is that the
> odbc "swallows" the hint, treating it as a comment.
>
> Database is 9.2.0.8, odbc is Oracle ODBC Driver, Release 11.2.0.1.0
>
> Of course it also could be that the *application* using the odbc is
> "swallowing" the hint, not the odbc itself.
>
> Any ideas?
>
> Daria
Look at what it is executing on the server. There are various ways to do that, you can drill into sessions with dbconsole or oem, you can trace the code, you can see sql in dba views. Do you have a dba you can work with? What access do you have to the db on the server.
jg
-- _at_home.com is bogus. http://www.itproportal.com/2012/02/21/oracle-prolonges-life-of-jdk-6/Received on Tue Feb 21 2012 - 10:49:16 CST