Re: Forcing an account to use rule-based optimization

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 16 Aug 1999 21:17:03 +0200
Message-ID: <934831043.6930.0.pluto.d4ee154e@news.demon.nl>

Hi Mike,
This is easily resolved:
set the optimizer_mode in init.ora to choose. Analyze all your tables (you need to do that anyway) except for the schema with the purchased app.
While no statistics are available it will automagically use the rule-based optimizer.

Hth,

Sybrand Bakker, Oracle DBA

<mike.lacy_at_alcoa.com> wrote in message news:7p9jqq$fac$1_at_nnrp1.deja.com...
> We are running Oracle 7.3.4.x with the cost based optimizer set as the
> default. We purchased an application that works much better if it uses
> rule based optimization. Can I force the application's account to use
> rule based? The connection comes through ODBC and we don't have anyway
> to send an "alter session ..." command from the application. Is there
> a login script for a user connecting through ODBC? Any ideas?
>
> Thanks,
> Mike
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Aug 16 1999 - 14:17:03 CDT