Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OPTIMIZER
Is it possible to find out which optimizer goal has been decided in
SQL_PLUS.
I can use the
alter session set optimizer_goal = FIRST_ROWS;
to set it to a neww value, however, how do I find out the original value.
Regards
Anthony.Millard_at_Ramesys.Com Received on Fri Aug 10 2001 - 08:38:34 CDT