Re: PLSQL execution model

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 28 Aug 1999 00:42:53 GMT
Message-ID: <37c93005.5855740@netnews.worldnet.att.net>

On Fri, 27 Aug 1999 10:56:29 GMT,
chris.angus_at_acsol.freeserve.co.uk wrote:

>as there seems to be a delay the first time I run a large
>stored procedure before it does anything useful

The delay may be because Oracle has to load the procedure into memory. You can pin it, causing Oracle to preload it. Look at the documentation for the dbms_shared_pool package.

Jonathan Received on Fri Aug 27 1999 - 19:42:53 CDT