Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Optimizer goal by schema, dbms_system proc??
Great idea ... thanks!! I know what you mean, but these are third
party apps and I can't change the SQL they generate (no hints).
Domenic.
"Anurag Varma" <avarmadba.skipthis_at_yahoo.com> wrote in message news:<ug_kb.9133$PZ1.2030_at_nwrdny03.gnilink.net>...
> "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 Tue Oct 21 2003 - 11:14:58 CDT