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 -> Re: Execution plan in stored procedures

Re: Execution plan in stored procedures

From: Marc Mazerolle <informaze_at_sympatico.ca>
Date: Mon, 21 Jun 1999 19:13:45 GMT
Message-ID: <376E9058.77043144@sympatico.ca> 





This is not DB2, if SQL stmt not in memory, plan is built when stmt is issued.



Setting optimizer_goal from SQL*Plus before issuing has no impact.



Regards,



Marc



Adrian Bowen wrote:



> Are plans not frozen when a package is built, though? I've been trustingly


> setting optimiser_goal from SQLPlus before issuing CREATE PACKAGE BODY,


> assuming that the execution plans for implicit and explicit cursors within


> the package would then be fixed.


>


> Adrian.





Received on Mon Jun 21 1999 - 14:13:45 CDT












Original text of this message













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