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: Adrian Bowen <adrian_at_raptor.win-uk.net>
Date: Mon, 21 Jun 1999 17:30:07 +0100
Message-ID: <7klpbv$h07$1@laura.pcug.co.uk> 





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 - 11:30:07 CDT












Original text of this message













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