Re: PLSQL execution model

From: Alla Gribov <alla.gribov_at_metatel.com>
Date: 27 Aug 1999 05:29:32 PDT
Message-ID: <37C692E9.A7EC1362@metatel.com>

Hi Chris;

> 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?

The whole point of having stored procedures is because they are pre-compiled.

> as there seems to be a delay the first time I run a large
> stored procedure before it does anything useful
The reason for the delay, is that for the first run stored procedure is being cached. Every other time you call it after that, Oracle will use cached version.

Alla Gribov Received on Fri Aug 27 1999 - 07:29:32 CDT