Oracle80.exe stack growth

From: Johan Wegener <xjw_at_xdde.xdk>
Date: Tue, 7 Sep 1999 11:52:06 +0200
Message-ID: <7r2n4c$euk$1@news101.telia.com>

Hello,

I am trying to understand how Oracle 8.0.4/NT handles PL/SQL procedure calls, particularly how procedure calls impacts the size of the Oracle80 executable.

On my small server, running the small (extreme) sample below increases the size of the Oracle80.exe (according to the task manager) from app. 6 MB in its dormant state to more than 76 MB during and after the execution. This means something like 80 bytes are allocated per procedure invokation! The sample performs 1 million recursive calls.

So can anybody shed any light onto the following:

• How does Oracle allocate the PL/SQL stack? It obviously does not use SGA memory for this. Does it use the hardware stack or does it maintain its own?
• Are there any init.ora parameters that influences this?
• Is it possible to "pin" the stack so that Oracle does not need to allocate/deallocate it dynamically?
• Can anybody point me to a web-site or book that explains how Oracle handles the PL/SQL stack?

declare

   nMax pls_integer := 1000000;
   n pls_integer := 0;
   procedure myfunc
   is
   begin

      n := n + 1;
      if n >= nMax
      then
         return;
      else
         myfunc;
      end if;

   end myfunc;
begin

   myfunc;
end;

Any comment is appreciated, thanks,
Johan Received on Tue Sep 07 1999 - 04:52:06 CDT