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: Adhoc query v. PL/SQL

Re: Adhoc query v. PL/SQL

From: Keith Boulton <boulke_at_globalnet.co.nospamuk>
Date: Wed, 26 Aug 1998 17:04:42 GMT
Message-ID: <35e439bf.36360603@news.globalnet.co.uk> 





On Wed, 26 Aug 1998 10:03:12 +0100, Richard Hennessy
<c-hennessyr_at_mail.dec.com> wrote:




>Do stored procedures not get parsed once, when they get created


>? Or do they get parsed


>every time they get called ?


>





After a database instance has been restarted, stored procedures are
reparsed at first execution. The parsed form is retained until it is
aged out of the shared pool.
Received on Wed Aug 26 1998 - 12:04:42 CDT












Original text of this message













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