Re: HELP: Stored Procedure performance question
From: Simon Hedges <shedges_at_hhhh.freeserve.co.uk>
Date: Mon, 17 May 1999 18:33:18 +0100
Message-ID: <7hpjq2$ln6$1_at_news4.svr.pol.co.uk>
Date: Mon, 17 May 1999 18:33:18 +0100
Message-ID: <7hpjq2$ln6$1_at_news4.svr.pol.co.uk>
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 - 19:33:18 CEST