Re: Compiling & Executing Stored Procedures

In article <548o2j$idl_at_newsbf02.news.aol.com>,

   kjphilbr13_at_aol.com (KJPhilbr13) wrote:
>Using Oracle 7.2...
>I'm sure this is a really stupid question but...How do you Compile a
>Stored Procedure? I have worked with ProCobol, ProFortran and ProC in
>which I did a precompile before a regular compile and link...But I am now
>only interested in CREATE OR REPLACE a standalone procedure that will be
>called external of the Oracle environment...

when they are executed the first time, they will be compiled and stored in memory, then executed.

>Also, can anyone tell me if it is true that a stored procedure, when
>called, creates an instance of itself which executes...So like in my case,
>there might be 30,000 calls to the same procedure per minute. Would that
>be a problem? Would there need to be any special settings on the tables
>(for better performance) it was updating? (In this case all updates are
>actually inserts...)

just the opposite. the generated code is stored in memory and re-used serially by anyone who calls it. 30,000 calls will all use the same code memory, but each will create a stack for temporary variables. this is automatic.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.