PLSQL execution model

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

is there any way to order a pre-fetch at connect time? in the same way thay you would rewrite

sum += x[n+0];
sum += x[n+1];
sum += x[n+2];
sum += x[n+3];
sum += x[n+4];
sum += x[n+5];
sum += x[n+6];
sum += x[n+7];

as

garb = x[n+16];
sum += x[n+0];
sum += x[n+1];
sum += x[n+2];
sum += x[n+3];
sum += x[n+4];
sum += x[n+5];
sum += x[n+6];
sum += x[n+7];

inside a loop

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 05:56:29 CDT