Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Session optimizer goal and PLSQL

Session optimizer goal and PLSQL

From: Andrew <ABryndin_at_retailpro.com>
Date: 14 Jun 2001 13:16:41 -0700
Message-ID: <2bfebe60.0106141216.5eee14d0@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US