Re: PLSQL execution model

chris.angus_at_acsol.freeserve.co.uk wrote:
>
> 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?
> as there seems to be a delay the first time I run a large
> stored procedure before it does anything useful
>

Chris,

It does have to load the first time in memory. If the compiled source is large mamory may run out. The next package that is called may push the unused source out. So beware of a lot off large packages from wich you use only a little.
You can pinn or pre-load some sources in memory so that won't be pushed out.

Regards,
André Received on Wed Sep 01 1999 - 23:28:50 CEST