Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Session optimizer goal and PLSQL
I use Oracle 8.1.7 EE for NT
Have database instance optimizer goal=choose, for the session
first_rows.
Oracle documentation states:
"The optimizer goal applies only to queries submitted directly. Use
hints to determine the access path for any SQL statements submitted
from within PL/SQL. The ALTER SESSION... SET OPTIMIZER_MODE statement
does not affect SQL that is run from within PL/SQL."
When I traced my session, trace file shows for all SQL issued from
PLSQL package optimizer goal inhereted from the session i.e FIRST_ROWS
(no direct hints on packaged SQL)
Is it error in documentation or glitch in tkprof? How could I know the
real execution plan for such PLSQL SQL statements?
Received on Thu Jun 14 2001 - 15:16:41 CDT