Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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