Optimizer goal by schema, dbms_system proc??

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. Received on Mon Oct 20 2003 - 18:16:45 CDT