PLSQL execution model
From: <chris.angus_at_acsol.freeserve.co.uk>
Date: Fri, 27 Aug 1999 10:56:29 GMT
Message-ID: <7q5qsr$bhn$1_at_nnrp1.deja.com>
Hi,
Date: Fri, 27 Aug 1999 10:56:29 GMT
Message-ID: <7q5qsr$bhn$1_at_nnrp1.deja.com>
Hi,
[Quoted] [Quoted] 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?
[Quoted] [Quoted] 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 - 12:56:29 CEST