Re: Optimiser oddity in PL./SQL

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:

>An interesting little quirk I came across recently which
>may affect anyone trying to package SQL into PL./SQL
>to produce an 'object-like' front-end.
>
>Regardless of the optimizer_mode set in the init.ora file,
>and SQL sent to the database from PL/SQL will be sent
>with a local optimizer_goal of CHOOSE.
>
>I called the support desk about this, and was told that
>this is not a bug - it was just deemed to be a sensible
>approach. Unfortunately it is something of an irritant at
>one of the sites I have just visited.

[...]

Jonathan,

thanks for pointing this out.

That's a really strange behaviour, I could reproduce this here at home = with
8.0.5/Linux. However if you have optimizer_mode=rule in the instance parameter file, it does not happen; only cost-based modes seem to be affected.

Merry Xmas and a great new year,
Peter

--
Peter Schneider
pschneider_at_knuut.de Received on Wed Dec 23 1998 - 15:47:24 CST