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

Home -> Community -> Usenet -> c.d.o.misc -> execution plan of a stored procedure

execution plan of a stored procedure

From: roark <RodionRaskolnikov_at_gmail.com>
Date: 9 Jan 2005 22:37:47 -0800
Message-ID: <1105339067.031309.248080@c13g2000cwb.googlegroups.com> 





hi,



A stored procedure is said to be 'pre-compiled'. In oracle 9i, is the
execution plan of the stored proc part of this compiling process? I
mean, if the CBO statistics change, will the stored procedure still
retain the old plan?



thanks,


roark
Received on Mon Jan 10 2005 - 00:37:47 CST












Original text of this message













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