Re: Oracle 10g and Odbc

From: Bertie Brink <bhb_at_donotspammailme.com>
Date: Sun, 09 Jul 2006 14:42:19 -0400
Message-ID: <12b2k03o8a4t870@news.supernews.com>

Michael Squires wrote:
> In article <12audvgqs9k05f1_at_news.supernews.com>,
> Bertie Brink <bhb_at_donotspammailme.com> wrote:

>> Oracle 10g has a problem with Oracle Win ODBC drivers. The regular

>
> 10g r1 or r2? The 10g r2 ODBC drivers in the client are working quite well for me.
>
> The 10g instant client also worked OK; I only had trouble with the r1 standard client.

The problem occurred with 10Gr2. The problem exists only when ODBC catalog related access is made through ODBC such as an Access or Word like program calling APIs that mine for column or table names and such.

The driver spews out a lot of /*RULE*/ hint embedded sql statements which you will notice in the trace logs. These will run very slow in 10g because the rule based optimizer being deprecated. User sql statements are fine however provided they do not have rule based hints.

Can some one provide details on what exactly was done with the rule based optimizer in 10g?

Regards,

Bertie Brink
http://www.setdefault.com/bertie Received on Sun Jul 09 2006 - 13:42:19 CDT