Re: Optimizer goal by schema, dbms_system proc??

"Domenic G." <domenicg_at_hotmail.com> wrote in message news:c7e08a19.0310201516.7ee0a0d8_at_posting.google.com...
> Is there a way to change the optimizer mode in another session through
> a dbms_system procedure so that the other session does not need to
> issue an "alter session set optimizer_goal = first_rows_1" (as an
> example)? Or, is it possible to set a default optimizer mode by
> schema that differs from the database-wide optimizer mode? I have two
> schemas in one db that perform optimally with two different optimizer
> modes.
>
> Thanks in advance for all replies ...
>
> Domenic.

You seem to be fixing the symptom rather than the problem.

However, what you want can be done by creating a database logon trigger which changes the
optimizer goal for the respective user.

Anurag Received on Mon Oct 20 2003 - 18:32:42 CDT