Re: PLSQL execution model

From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Fri, 27 Aug 1999 19:29:59 +0100
Message-ID: <7q6leg$i9s$1@news5.svr.pol.co.uk>

<chris.angus_at_acsol.freeserve.co.uk> wrote in message news:7q5qsr$bhn$1_at_nnrp1.deja.com...
> Hi,
>
> Does anyone know anything about oracle PLSQL execution model.
> What happens when you connect and call a procedure in a package
> which will call other (large) procedures in other packages.
>
> Does the database do a select for the compliled package code?
> Compile it on the fly?

All Procedure code is compiled. The same is true for triggers in Oracle 7.3 or later.

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

It's loading it into the cache.

Simon Hedges
Gloucester
UK Received on Fri Aug 27 1999 - 13:29:59 CDT