Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP: Stored Procedure performance question
Hans wrote in message ...
>Are you sure that it is compiled! from my point of view it is normally
>impossible
>that PL/SQL Procedures are compiled (the execution plan is determined).
I'm
>just a beginner in Oracle, but there are features that I think makes it
>impossible
>that proc are compiled.
Oracle certainly claim that they are compiled. There was a lot of stuff in earlier versions of Oracle 7 about not using triggers for large volumes of code, but using a trigger to call procs, because procs were compiled.
(this is now obsolete because from 7.3, triggers are also compiled).
Simon Hedges
Gloucester
UK
Received on Mon May 17 1999 - 12:33:18 CDT
![]() |
![]() |